{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Page 1a, Cost of the agreement","Page 1b, Other Agreement 1","Step & Column Costs Example","Compounded Costs Example","Page 1c, Other Agreement 2","Page 1d, Other Agreement 3","Page 1e, Other Agreement 4","Page 1 Total - All Agreements","Page 2, Explanations","Page 3 Explanations","Page 4a, Unrest GF","Page 4b. Rest GF","Page 4c Combined GF","Page 4d Adult Education Fund","Page 4e Child Development Fund","Page 4f Cafeteria Fund","Page 4g Other Enterprise Fund","Page 4h Other Fund","Page 4i, Column 3 Explanations","Page 5a MYP Unrest GF","Page 5b MYP Rest GF","Page 5c MYP Combined","Page 6, Reserve Levels","Page 7, Variance & Deficits","Page 8, Certification","Page 9, Explanations and Other"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":402,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Page 1a, Cost of the agreement","index":0,"n_rows":130,"n_cols":10,"rows_kept":130,"cut":false,"hidden":false,"merged":[[57,4,57,6],[50,2,50,3],[49,0,50,1],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[34,2,34,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[32,0,33,0],[29,0,30,0],[25,0,26,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,0,22,1],[22,4,24,6],[23,0,23,1],[24,0,24,1],[31,2,31,3],[2,9,4,9],[17,0,17,4],[19,0,19,6],[20,0,20,6],[21,0,21,6],[4,0,4,1],[16,0,16,2],[7,0,7,2],[8,0,8,2],[15,0,15,2],[10,0,10,6],[11,0,11,6],[3,2,3,6],[4,2,4,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,1],[6,0,6,6]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT",null,null,null,null,null,null,null,null,"Specific Instructions for Completion of"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5",null,null,null,null,null,null,null,null,"Public Disclosure of Proposed Collective Bargaining Agreement"]
[]
["Name of School District:"]
["Name of Unit:"]
["Certificated, Classified, Other:"]
[]
["The proposed agreement covers the period beginning:",null,null,null,null,"and ending:"]
[null,null,null,null,"(date)",null,"(date)"]
[]
["If this agreement is part of a multi-year agreement, indicate all fiscal years covered by the agreement. "]
["Enter the on-schedule % increase for each fiscal year. (Do not report off-schedule increases in this section)"]
[null,"Fiscal Year",null,null,{"$f":"TEXT(LEFT(C13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(C13,2)+1, \"00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(LEFT(E13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(E13,2)+1, \"00\")","v":{"$error":"#VALUE!"}}]
[null,"% Increase"]
[]
["The Governing Board will act upon this agreement on:"]
[null,null,null,null,null,"(date)"]
["Budget Revisions to be adopted by: (no later than 45 days after approval)",null,null,null,null,{"$f":"IF(F16=0,\"\",(F16+45))","v":""}]
[null,null,null,null,null,"(date)",null,null,null,{"$f":"IF(C6=\"Management/Confidential\", \"Pursuant to Government Code Section 54956, Management costs must be disclosed at a Regulary Scheduled Board meeting\",\"\")","v":""}]
["Note:  This form, along with a copy of the proposed agreement, must be submitted to the County Office at least ten (10) working days prior to the date the Governing Board will take action.",null,null,null,null,null,null,null,null,"Section A, Page 1:  Proposed Change in Compensation"]
[]
["A.  Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1      Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"C13","v":0},{"$f":"E13","v":{"$error":"#VALUE!"}},{"$f":"F13","v":{"$error":"#VALUE!"}}]
["1.","Salary Schedule                                                           ",null,null,{"$f":"+C28*C14","v":0},{"$f":"((C28+E28)*E14)+E28","v":0},{"$f":"+((C28+F28)*F14)+F28","v":0}]
[null,"On-Schedule cumulative increase",null,null,{"$f":"IF($C$28>0,E28/C28,IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,F28/(C28+E28),IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,G28/(C28+E28+F28),IF($C$28=0,\"\"))","v":""}]
["2.","Step & Column"]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C30>0,E30/C30,IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,F30/SUM(C30+E30),IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,G30/SUM(C30+E30+F30),IF(C30=0,\" \"))","v":" "}]
["3.","Other Compensation "]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc.","(Describe)",null,null,null,null,null,null,"Compounded Costs Example"]
[null,null,null,null,{"$f":"IF(C33>0,E33/C33,IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,F33/SUM(C33+E33),IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,G33/SUM(C33+E33+F33),IF(C33=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc.",null,{"$f":"(D28+D33)*20.97%","v":0}]
[null,null,null,null,{"$f":"IF(C36=0,0,E36/C36)","v":0},{"$f":"IF(C36=0,0,F36/SUM(C36+E36))","v":0},{"$f":"IF(C36=0,0,G36/SUM(C36+E36+F36))","v":0}]
["5.","Health/Welfare Plans "]
[null,null,null,null,{"$f":"IF(C38>0,E38/C38,IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,F38/SUM(C38+E38),IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,G38/SUM(C38+E38+F38),IF(C38=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C28++C30+C33+C36+C38","v":0},null,{"$f":"E28+E30+E33+E36+E38","v":0},{"$f":"F28+F30+F33+F36+F38","v":0},{"$f":"G28+G30+G33+G36+G38","v":0}]
[null,null,null,null,{"$f":"IF(C40=0,0,E40/C40)","v":0},{"$f":"IF(C40=0,0,F40/SUM(C40+E40))","v":0},{"$f":"IF(C40=0,0,G40/SUM(C40+E40+F40))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)",null,null,null,null,null,null,null,"Step & Column Costs Example"]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C42=0,0,C40/C42)","v":0},null,{"$f":"IF(C42=0,0,E40/C42)","v":0},{"$f":"IF(C42=0,0,F40/C42)","v":0},{"$f":"IF(C42=0,0,G40/C42)","v":0}]
[null,null,null,null,{"$f":"IF(C43=0,0,E43/C43)","v":0},{"$f":"IF(C43=0,0,F43/SUM(C43+E43))","v":0},{"$f":"IF(C43=0,0,G43/SUM(C43+E43+F43))","v":0}]
[]
[null,"Is the district settling with additional bargaining unit(s) or unrepresented at this time ? ",null,null,null,"Y/N"]
[]
[]
["Impact on Other Funds (Click buttons below to unhide p. 4 for the fund)"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E27","v":0},{"$f":"+F27","v":{"$error":"#VALUE!"}},{"$f":"+G27","v":{"$error":"#VALUE!"}}]
["Y/N","Adult Education Fund",null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Child Development Fund",null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Cafeteria Fund",null,null,null,null,null,null,{"$f":"IF(A54=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Enterprise Fund",null,null,null,null,null,null,{"$f":"IF(A55=\"Yes\",\"Optional- click on the link in cell B55 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Fund",null,null,null,null,null,null,{"$f":"IF(A56=\"Yes\",\"Optional- click on the link in cell B56 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
["Buttons to unhide page 4s for other funds:",null,null,null,"Buttons to unhide page 1b -1d for other agreements:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E125","v":"2026-27"},{"$f":"+E126","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E126","v":"2027-28"},{"$f":"+E127","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Page 1b, Other Agreement 1","index":1,"n_rows":126,"n_cols":9,"rows_kept":126,"cut":false,"hidden":false,"merged":[[15,0,15,2],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,1],[4,0,4,1],[6,0,6,6],[7,0,7,2],[8,0,8,2],[10,0,10,6],[11,0,11,6],[3,2,3,6],[4,2,4,6],[5,2,5,4],[31,2,31,3],[16,0,16,2],[17,0,17,4],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,1],[22,4,24,6],[23,0,23,1],[24,0,24,1],[25,0,26,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,0,30,0],[47,0,48,1],[48,2,48,3],[32,0,33,0],[34,2,34,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5"]
["If the district is approving a settlement with a second unit or unrepresented at this time, place a \"Y\" in H3, otherwise indicate N/A here:"]
["Name of School District:",null,{"$f":"+'Page 1a, Cost of the agreement'!C4","v":0}]
["Name of Unit:"]
["Certificated, Classified, Other:"]
[]
["The proposed agreement covers the period beginning:",null,null,null,null,"and ending:"]
[null,null,null,null,"(date)",null,"(date)"]
[]
["If this agreement is part of a multi-year agreement, indicate all fiscal years covered by the agreement. "]
["Enter the on-schedule % increase for each fiscal year. (Do not report off-schedule increases in this section)"]
[null,"Fiscal Year",{"$f":"'Page 1a, Cost of the agreement'!C13","v":0},null,{"$f":"TEXT(LEFT(C13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(C13,2)+1, \"00\")","v":"0001-01"},{"$f":"TEXT(LEFT(E13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(E13,2)+1, \"00\")","v":"0002-02"}]
[null,"% Increase"]
[]
["The Governing Board will act upon this agreement on:"]
[null,null,null,null,null,"(date)"]
["Budget Revisions to be input by: (no later than 45 days after approval)",null,null,null,null,{"$f":"IF(F16=0,\"\",(F16+45))","v":""}]
[null,null,null,null,null,"(date)"]
["Note:  This form, along with a copy of the proposed agreement, must be submitted to the County Office at least ten (10) working days prior to the date the Governing Board will take action."]
[]
["A.  Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"C13","v":0},{"$f":"VLOOKUP($E27,$E$108:$G$124,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($E27,$E$108:$G$124,3)","v":{"$error":"#N/A"}}]
["1.","Salary Schedule                                                           ",null,null,{"$f":"+C28*C14","v":0},{"$f":"((C28+E28)*E14)+E28","v":0},{"$f":"+((C28+F28)*F14)+F28","v":0}]
[null,"On-Schedule cumulative increase",null,null,{"$f":"IF($C$28>0,E28/C28,IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,F28/(C28+E28),IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,G28/(C28+E28+F28),IF($C$28=0,\"\"))","v":""}]
["2.","Step & Column"]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C30>0,E30/C30,IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,F30/SUM(C30+E30),IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,G30/SUM(C30+E30+F30),IF(C30=0,\" \"))","v":" "}]
["3.","Other Compensation "]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc.","(Describe)"]
[null,null,null,null,{"$f":"IF(C33>0,E33/C33,IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,F33/SUM(C33+E33),IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,G33/SUM(C33+E33+F33),IF(C33=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc.",null,{"$f":"(D28)*33.16%","v":0}]
[null,null,null,null,{"$f":"IF(C36=0,0,E36/C36)","v":0},{"$f":"IF(D36=0,0,F36/SUM(C36+E36))","v":0},{"$f":"IF(C36=0,0,G36/SUM(C36+E36+F36))","v":0}]
["5.","Health/Welfare Plans "]
[null,null,null,null,{"$f":"IF(C38>0,E38/C38,IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,F38/SUM(C38+E38),IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,G38/SUM(C38+E38+F38),IF(C38=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C28++C30+C33+C36+C38","v":0},null,{"$f":"E28+E30+E33+E36+E38","v":0},{"$f":"F28+F30+F33+F36+F38","v":0},{"$f":"G28+G30+G33+G36+G38","v":0}]
[null,null,null,null,{"$f":"IF(C40=0,0,E40/C40)","v":0},{"$f":"IF(C40=0,0,F40/SUM(C40+E40))","v":0},{"$f":"IF(C40=0,0,G40/SUM(C40+E40+F40))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)"]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C42=0,0,C40/C42)","v":0},null,{"$f":"IF(C42=0,0,E40/C42)","v":0},{"$f":"IF(C42=0,0,F40/C42)","v":0},{"$f":"IF(C42=0,0,G40/C42)","v":0}]
[null,null,null,null,{"$f":"IF(C43=0,0,E43/C43)","v":0},{"$f":"IF(C43=0,0,F43/SUM(C43+E43))","v":0},{"$f":"IF(C43=0,0,G43/SUM(C43+E43+F43))","v":0}]
[]
[]
["Impact on Other Funds (unhide page 4s using buttons on bottom of page 1a)"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E27","v":0},{"$f":"+F27","v":{"$error":"#N/A"}},{"$f":"+G27","v":{"$error":"#N/A"}}]
["Y/N","Adult Education Fund",null,null,null,null,null,null,{"$f":"IF(A50=\"Yes\",\"Optional- click on the link in cell B50 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Child Development Fund",null,null,null,null,null,null,{"$f":"IF(A51=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Cafeteria Fund",null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Enterprise Fund",null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Fund ",null,null,null,null,null,null,{"$f":"IF(A54=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2013-14","2014-15","2015-16"]
[null,null,null,null,"2014-15","2015-16","2016-17"]
[null,null,null,null,"2015-16","2016-17","2017-18"]
[null,null,null,null,"2016-17","2017-18","2018-19"]
[null,null,null,null,"2017-18","2018-19","2019-20"]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E121","v":"2026-27"},{"$f":"+E122","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E122","v":"2027-28"},{"$f":"+E123","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Step & Column Costs Example","index":2,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":true,"merged":[[1,2,1,5],[11,2,11,5]]}
[null,null,null,null,null,null,null,null,"Salary Schedule for ABCDEFG Unfied School District (Before Settlement)"]
[null,null,"Annual Salary Before Settlement"]
["Employee Name","Current Yr Salary Placement","Prior Year Salary","Current Year","Year 2","Year 3",null,null,null,"Column"]
["Employee #1","BA+45, Step 2",{"$f":"+L5","v":70304},{"$f":"+L6","v":73116.160000000003},{"$f":"+L7","v":76040.806400000001},{"$f":"+L8","v":79082.438655999998},null,null,"Step","BA","BA+30","BA+45","BA+60","MA"]
[null,null,null,null,null,null,null,null,1,65000,{"$f":"+J5*104%","v":67600},{"$f":"+K5*104%","v":70304},73116.160000000003,76040.806400000001]
["Step & Column Cost prior to Agreement",null,null,{"$f":"+D4-C4","v":2812.1600000000035},{"$f":"+E4-D4","v":2924.6463999999978},{"$f":"+F4-E4","v":3041.6322559999971},null,null,2,{"$f":"+J5*104%","v":67600},{"$f":"+J6*104%","v":70304},73116.160000000003,{"$f":"+L6*102%","v":74578.483200000002},{"$f":"+M6*104%","v":77561.622528000007}]
[null,null,null,{"$f":"+D6/C4","v":4.0000000000000049E-2},{"$f":"+E6/D4","v":3.9999999999999966E-2},{"$f":"+F6/E4","v":3.9999999999999959E-2},null,null,3,{"$f":"+J6*104%","v":70304},73116.160000000003,76040.806400000001,77561.622528000007,{"$f":"+M7*104%","v":80664.087429120016}]
[null,null,null,null,null,null,null,null,4,73116.160000000003,76040.806400000001,79082.438655999998,80664.087429120002,{"$f":"+M8*104%","v":83890.650926284798}]
[null,null,null,null,null,null,null,null,5,76040.806400000001,79082.438655999998,82245.736202240005,83890.650926284812,{"$f":"+M9*104%","v":87246.276963336204}]
[]
[]
[null,null,"Annual Salary After Agreement","Annual Salary Before Settlement"]
["Employee Name","Current Yr Salary Placement","Prior Year Salary","Current Year","Year 2","Year 3",null,null,"Salary Schedule for ABCDEFG Unfied School District (After Settlement)"]
["Employee #1","BA+45, Step 2",{"$f":"+L17","v":71710.080000000002},{"$f":"+L18","v":74578.483200000002},{"$f":"+L19","v":77561.622528000007},{"$f":"+L20","v":80664.087429120002},null,null,null,"(with",0.02,"Increase)"]
[null,null,null,null,null,null,null,null,null,"Column"]
[null,null,null,null,null,null,null,null,"Step","BA","BA+30","BA+45","BA+60","MA"]
["Step & Column Cost after the Agreement",null,null,{"$f":"+D14-C14","v":2868.4032000000007},{"$f":"+E14-D14","v":2983.1393280000048},3102.4649011199945,null,null,1,{"$f":"+J5*(100%+$K$14)","v":66300},68952,71710.080000000002,74578.483200000002,77561.622528000007]
[null,null,null,{"$f":"+D17/C4","v":4.080000000000001E-2},{"$f":"+E17/D4","v":4.0800000000000065E-2},{"$f":"+F17/E4","v":4.0799999999999927E-2},null,null,2,68952,71710.080000000002,74578.483200000002,76070.052863999997,79112.854978560004]
[null,null,null,null,null,null,null,null,3,71710.080000000002,74578.483200000002,77561.622528000007,79112.854978560004,82277.369177702421]
[null,null,null,null,null,null,null,null,4,74578.483200000002,77561.622528000007,80664.087429120002,82277.369177702407,85568.463944810501]
[null,null,null,null,null,null,null,null,5,77561.622528000007,80664.087429120002,83890.650926284812,85568.463944810515,88991.20250260293]
[null,null,"Fiscal Impact of Proposed Agreement                                          "]
["Step & Column","Annual Cost Prior to Proposed Settlement","Current Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
["Increase or decrease in the cost of step & column as a result of the settlement",{"$f":"+D6","v":2812.1600000000035},{"$f":"+D17-D6","v":56.243199999997159},{"$f":"+E17-E6","v":58.492928000006941},{"$f":"+F17-F6","v":60.832645119997323}]

{"sheet":"Compounded Costs Example","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Compounding effects of a multi-year agreement "]
[]
["Example of an employee with an annual Salary of $100,000"]
["Multi-year agreement for 3 Years "]
["Year 1 increase:",0.03]
["Year 2 increase:",0.05]
["Year 3 increase:",0.04]
[]
[]
["Annual Salary",100000,"Year 1","Year 2","Year 3"]
["% increase",null,{"$f":"+B5","v":0.03},{"$f":"+B6","v":0.05},{"$f":"+B7","v":0.04}]
["Revised Salary with increase",null,{"$f":"+B10*1.03","v":103000},{"$f":"+C12*1.05","v":108150},{"$f":"+D12*1.04","v":112476}]
[]
["Annual increase with compounding ",null,{"$f":"+C12-B10","v":3000},{"$f":"+D12-B10","v":8150},{"$f":"+E12-B10","v":12476}]
["Annual increase without compounding ",null,{"$f":"+B10*C11","v":3000},{"$f":"+B10*D11","v":5000},{"$f":"+B10*E11","v":4000}]

{"sheet":"Page 1c, Other Agreement 2","index":4,"n_rows":126,"n_cols":9,"rows_kept":126,"cut":false,"hidden":false,"merged":[[47,0,48,1],[48,2,48,3],[32,0,33,0],[34,2,34,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[31,2,31,3],[17,0,17,4],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,1],[22,4,24,6],[23,0,23,1],[24,0,24,1],[25,0,26,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,0,30,0],[16,0,16,2],[0,0,0,6],[1,0,1,6],[3,0,3,1],[4,0,4,1],[6,0,6,6],[7,0,7,2],[8,0,8,2],[10,0,10,6],[11,0,11,6],[15,0,15,2],[3,2,3,6],[4,2,4,6],[5,2,5,4],[2,0,2,6]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5"]
["If the district is approving a settlement with a third unit or unrepresented at this time, place a \"Y\" in H3, otherwise indicate N/A here:"]
["Name of School District:",null,{"$f":"+'Page 1a, Cost of the agreement'!C4","v":0}]
["Name of Bargaining Unit:"]
["Certificated, Classified, Other:"]
[]
["The proposed agreement covers the period beginning:",null,null,null,null,"and ending:"]
[null,null,null,null,"(date)",null,"(date)"]
[]
["If this agreement is part of a multi-year agreement, indicate all fiscal years covered by the agreement. "]
["Enter the on-schedule % increase for each fiscal year. (Do not report off-schedule increases in this section)"]
[null,"Fiscal Year",{"$f":"'Page 1a, Cost of the agreement'!C13","v":0},null,{"$f":"TEXT(LEFT(C13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(C13,2)+1, \"00\")","v":"0001-01"},{"$f":"TEXT(LEFT(E13,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(E13,2)+1, \"00\")","v":"0002-02"}]
[null,"% Increase"]
[]
["The Governing Board will act upon this agreement on:"]
[null,null,null,null,null,"(date)"]
["Budget Revisions to be input by: (no later than 45 days after approval)",null,null,null,null,{"$f":"IF(F16=0,\"\",(F16+45))","v":""}]
[null,null,null,null,null,"(date)"]
["Note:  This form, along with a copy of the proposed agreement, must be submitted to the County Office at least ten (10) working days prior to the date the Governing Board will take action."]
[]
["A.  Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"C13","v":0},{"$f":"VLOOKUP($E27,$E$108:$G$124,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($E27,$E$108:$G$124,3)","v":{"$error":"#N/A"}}]
["1.","Salary Schedule                                                           ",null,null,{"$f":"+C28*C14","v":0},{"$f":"((C28+E28)*E14)+E28","v":0},{"$f":"+((C28+F28)*F14)+F28","v":0}]
[null,"On-Schedule cumulative increase",null,null,{"$f":"IF($C$28>0,E28/C28,IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,F28/(C28+E28),IF($C$28=0,\"\"))","v":""},{"$f":"IF($C$28>0,G28/(C28+E28+F28),IF($C$28=0,\"\"))","v":""}]
["2.","Step & Column"]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C30>0,E30/C30,IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,F30/SUM(C30+E30),IF(C30=0,\" \"))","v":" "},{"$f":"IF(C30>0,G30/SUM(C30+E30+F30),IF(C30=0,\" \"))","v":" "}]
["3.","Other Compensation "]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc.","(Describe)"]
[null,null,null,null,{"$f":"IF(C33>0,E33/C33,IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,F33/SUM(C33+E33),IF(C33=0,\" \"))","v":" "},{"$f":"IF(C33>0,G33/SUM(C33+E33+F33),IF(C33=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc."]
[null,null,null,null,{"$f":"IF(C36=0,0,E36/C36)","v":0},{"$f":"IF(C36=0,0,F36/SUM(C36+E36))","v":0},{"$f":"IF(C36=0,0,G36/SUM(C36+E36+F36))","v":0}]
["5.","Health/Welfare Plans "]
[null,null,null,null,{"$f":"IF(C38>0,E38/C38,IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,F38/SUM(C38+E38),IF(C38=0,\" \"))","v":" "},{"$f":"IF(C38>0,G38/SUM(C38+E38+F38),IF(C38=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C28++C30+C33+C36+C38","v":0},null,{"$f":"E28+E30+E33+E36+E38","v":0},{"$f":"F28+F30+F33+F36+F38","v":0},{"$f":"G28+G30+G33+G36+G38","v":0}]
[null,null,null,null,{"$f":"IF(C40=0,0,E40/C40)","v":0},{"$f":"IF(C40=0,0,F40/SUM(C40+E40))","v":0},{"$f":"IF(C40=0,0,G40/SUM(C40+E40+F40))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)"]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C42=0,0,C40/C42)","v":0},null,{"$f":"IF(C42=0,0,E40/C42)","v":0},{"$f":"IF(C42=0,0,F40/C42)","v":0},{"$f":"IF(C42=0,0,G40/C42)","v":0}]
[null,null,null,null,{"$f":"IF(C43=0,0,E43/C43)","v":0},{"$f":"IF(C43=0,0,F43/SUM(C43+E43))","v":0},{"$f":"IF(C43=0,0,G43/SUM(C43+E43+F43))","v":0}]
[]
[]
["Impact on Other Funds (unhide page 4s using buttons on bottom of page 1a)"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E27","v":0},{"$f":"+F27","v":{"$error":"#N/A"}},{"$f":"+G27","v":{"$error":"#N/A"}}]
["Y/N","Adult Education Fund",null,null,null,null,null,null,{"$f":"IF(A50=\"Yes\",\"Optional- click on the link in cell B50 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Child Development Fund",null,null,null,null,null,null,{"$f":"IF(A51=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Cafeteria Fund",null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Enterprise Fund",null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Fund ",null,null,null,null,null,null,{"$f":"IF(A54=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2013-14","2014-15","2015-16"]
[null,null,null,null,"2014-15","2015-16","2016-17"]
[null,null,null,null,"2015-16","2016-17","2017-18"]
[null,null,null,null,"2016-17","2017-18","2018-19"]
[null,null,null,null,"2017-18","2018-19","2019-20"]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E121","v":"2026-27"},{"$f":"+E122","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E122","v":"2027-28"},{"$f":"+E123","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Page 1d, Other Agreement 3","index":5,"n_rows":125,"n_cols":9,"rows_kept":125,"cut":false,"hidden":true,"merged":[[41,2,41,3],[42,2,42,3],[46,0,47,1],[47,2,47,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[33,2,33,3],[21,0,21,1],[21,4,23,6],[22,0,22,1],[23,0,23,1],[24,0,25,1],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,0,29,0],[30,2,30,3],[31,0,32,0],[20,0,20,6],[4,2,4,4],[5,0,5,6],[6,0,6,2],[7,0,7,2],[9,0,9,6],[10,0,10,6],[14,0,14,2],[15,0,15,2],[16,0,16,4],[18,0,18,6],[19,0,19,6],[0,0,0,6],[1,0,1,6],[2,0,2,1],[2,2,2,6],[3,0,3,1],[3,2,3,6]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5"]
["Name of School District:",null,{"$f":"+'Page 1a, Cost of the agreement'!C4","v":0}]
["Name of Bargaining Unit:"]
["Certificated, Classified, Other:"]
[]
["The proposed agreement covers the period beginning:",null,null,null,null,"and ending:"]
[null,null,null,null,"(date)",null,"(date)"]
[]
["If this agreement is part of a multi-year agreement, indicate all fiscal years covered by the agreement. "]
["Enter the on-schedule % increase for each fiscal year. (Do not report off-schedule increases in this section)"]
[null,"Fiscal Year",{"$f":"'Page 1a, Cost of the agreement'!C13","v":0},null,{"$f":"TEXT(LEFT(C12,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(C12,2)+1, \"00\")","v":"0001-01"},{"$f":"TEXT(LEFT(E12,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(E12,2)+1, \"00\")","v":"0002-02"}]
[null,"% Increase"]
[]
["The Governing Board will act upon this agreement on:"]
[null,null,null,null,null,"(date)"]
["Budget Revisions to be input by: (no later than 45 days after approval)",null,null,null,null,{"$f":"IF(F15=0,\"\",(F15+45))","v":""}]
[null,null,null,null,null,"(date)"]
["Note:  This form, along with a copy of the proposed agreement, must be submitted to the County Office at least ten (10) working days prior to the date the Governing Board will take action."]
[]
["A.  Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"C12","v":0},{"$f":"VLOOKUP($E26,$E$107:$G$123,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($E26,$E$107:$G$123,3)","v":{"$error":"#N/A"}}]
["1.","Salary Schedule                                                           ",null,null,{"$f":"+C27*C13","v":0},{"$f":"((C27+E27)*E13)+E27","v":0},{"$f":"+((C27+F27)*F13)+F27","v":0}]
[null,"On-Schedule cumulative increase",null,null,{"$f":"IF($C$27>0,E27/C27,IF($C$27=0,\"\"))","v":""},{"$f":"IF($C$27>0,F27/(C27+E27),IF($C$27=0,\"\"))","v":""},{"$f":"IF($C$27>0,G27/(C27+E27+F27),IF($C$27=0,\"\"))","v":""}]
["2.","Step & Column"]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C29>0,E29/C29,IF(C29=0,\" \"))","v":" "},{"$f":"IF(C29>0,F29/SUM(C29+E29),IF(C29=0,\" \"))","v":" "},{"$f":"IF(C29>0,G29/SUM(C29+E29+F29),IF(C29=0,\" \"))","v":" "}]
["3.","Other Compensation "]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc.","(Describe)"]
[null,null,null,null,{"$f":"IF(C32>0,E32/C32,IF(C32=0,\" \"))","v":" "},{"$f":"IF(C32>0,F32/SUM(C32+E32),IF(C32=0,\" \"))","v":" "},{"$f":"IF(C32>0,G32/SUM(C32+E32+F32),IF(C32=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc."]
[null,null,null,null,{"$f":"IF(C35=0,0,E35/C35)","v":0},{"$f":"IF(C35=0,0,F35/SUM(C35+E35))","v":0},{"$f":"IF(C35=0,0,G35/SUM(C35+E35+F35))","v":0}]
["5.","Health/Welfare Plans "]
[null,null,null,null,{"$f":"IF(C37>0,E37/C37,IF(C37=0,\" \"))","v":" "},{"$f":"IF(C37>0,F37/SUM(C37+E37),IF(C37=0,\" \"))","v":" "},{"$f":"IF(C37>0,G37/SUM(C37+E37+F37),IF(C37=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C27++C29+C32+C35+C37","v":0},null,{"$f":"E27+E29+E32+E35+E37","v":0},{"$f":"F27+F29+F32+F35+F37","v":0},{"$f":"G27+G29+G32+G35+G37","v":0}]
[null,null,null,null,{"$f":"IF(C39=0,0,E39/C39)","v":0},{"$f":"IF(C39=0,0,F39/SUM(C39+E39))","v":0},{"$f":"IF(C39=0,0,G39/SUM(C39+E39+F39))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)"]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C41=0,0,C39/C41)","v":0},null,{"$f":"IF(C41=0,0,E39/C41)","v":0},{"$f":"IF(C41=0,0,F39/C41)","v":0},{"$f":"IF(C41=0,0,G39/C41)","v":0}]
[null,null,null,null,{"$f":"IF(C42=0,0,E42/C42)","v":0},{"$f":"IF(C42=0,0,F42/SUM(C42+E42))","v":0},{"$f":"IF(C42=0,0,G42/SUM(C42+E42+F42))","v":0}]
[]
[]
["Impact on Other Funds (unhide page 4s using buttons on bottom of page 1a)"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E26","v":0},{"$f":"+F26","v":{"$error":"#N/A"}},{"$f":"+G26","v":{"$error":"#N/A"}}]
["Y/N","Adult Education Fund",null,null,null,null,null,null,{"$f":"IF(A49=\"Yes\",\"Optional- click on the link in cell B50 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Child Development Fund",null,null,null,null,null,null,{"$f":"IF(A50=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Cafeteria Fund",null,null,null,null,null,null,{"$f":"IF(A51=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Enterprise Fund",null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Fund ",null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2013-14","2014-15","2015-16"]
[null,null,null,null,"2014-15","2015-16","2016-17"]
[null,null,null,null,"2015-16","2016-17","2017-18"]
[null,null,null,null,"2016-17","2017-18","2018-19"]
[null,null,null,null,"2017-18","2018-19","2019-20"]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E120","v":"2026-27"},{"$f":"+E121","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E121","v":"2027-28"},{"$f":"+E122","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Page 1e, Other Agreement 4","index":6,"n_rows":125,"n_cols":9,"rows_kept":125,"cut":false,"hidden":true,"merged":[[41,2,41,3],[42,2,42,3],[46,0,47,1],[47,2,47,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[33,2,33,3],[21,0,21,1],[21,4,23,6],[22,0,22,1],[23,0,23,1],[24,0,25,1],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,0,29,0],[30,2,30,3],[31,0,32,0],[20,0,20,6],[4,2,4,4],[5,0,5,6],[6,0,6,2],[7,0,7,2],[9,0,9,6],[10,0,10,6],[14,0,14,2],[15,0,15,2],[16,0,16,4],[18,0,18,6],[19,0,19,6],[0,0,0,6],[1,0,1,6],[2,0,2,1],[2,2,2,6],[3,0,3,1],[3,2,3,6]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5"]
["Name of School District:",null,{"$f":"+'Page 1a, Cost of the agreement'!C4","v":0}]
["Name of Bargaining Unit:"]
["Certificated, Classified, Other:"]
[]
["The proposed agreement covers the period beginning:",null,null,null,null,"and ending:"]
[null,null,null,null,"(date)",null,"(date)"]
[]
["If this agreement is part of a multi-year agreement, indicate all fiscal years covered by the agreement. "]
["Enter the on-schedule % increase for each fiscal year. (Do not report off-schedule increases in this section)"]
[null,"Fiscal Year",{"$f":"'Page 1a, Cost of the agreement'!C13","v":0},null,{"$f":"TEXT(LEFT(C12,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(C12,2)+1, \"00\")","v":"0001-01"},{"$f":"TEXT(LEFT(E12,4)+1, \"0000\") & \"-\" & TEXT(RIGHT(E12,2)+1, \"00\")","v":"0002-02"}]
[null,"% Increase"]
[]
["The Governing Board will act upon this agreement on:"]
[null,null,null,null,null,"(date)"]
["Budget Revisions to be input by: (no later than 45 days after approval)",null,null,null,null,{"$f":"IF(F15=0,\"\",(F15+45))","v":""}]
[null,null,null,null,null,"(date)"]
["Note:  This form, along with a copy of the proposed agreement, must be submitted to the County Office at least ten (10) working days prior to the date the Governing Board will take action."]
[]
["A.  Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"C12","v":0},{"$f":"VLOOKUP($E26,$E$107:$G$123,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($E26,$E$107:$G$123,3)","v":{"$error":"#N/A"}}]
["1.","Salary Schedule                                                           ",null,null,{"$f":"+C27*C13","v":0},{"$f":"((C27+E27)*E13)+E27","v":0},{"$f":"+((C27+F27)*F13)+F27","v":0}]
[null,"On-Schedule cumulative increase",null,null,{"$f":"IF($C$27>0,E27/C27,IF($C$27=0,\"\"))","v":""},{"$f":"IF($C$27>0,F27/(C27+E27),IF($C$27=0,\"\"))","v":""},{"$f":"IF($C$27>0,G27/(C27+E27+F27),IF($C$27=0,\"\"))","v":""}]
["2.","Step & Column"]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C29>0,E29/C29,IF(C29=0,\" \"))","v":" "},{"$f":"IF(C29>0,F29/SUM(C29+E29),IF(C29=0,\" \"))","v":" "},{"$f":"IF(C29>0,G29/SUM(C29+E29+F29),IF(C29=0,\" \"))","v":" "}]
["3.","Other Compensation "]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc.","(Describe)"]
[null,null,null,null,{"$f":"IF(C32>0,E32/C32,IF(C32=0,\" \"))","v":" "},{"$f":"IF(C32>0,F32/SUM(C32+E32),IF(C32=0,\" \"))","v":" "},{"$f":"IF(C32>0,G32/SUM(C32+E32+F32),IF(C32=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc."]
[null,null,null,null,{"$f":"IF(C35=0,0,E35/C35)","v":0},{"$f":"IF(C35=0,0,F35/SUM(C35+E35))","v":0},{"$f":"IF(C35=0,0,G35/SUM(C35+E35+F35))","v":0}]
["5.","Health/Welfare Plans "]
[null,null,null,null,{"$f":"IF(C37>0,E37/C37,IF(C37=0,\" \"))","v":" "},{"$f":"IF(C37>0,F37/SUM(C37+E37),IF(C37=0,\" \"))","v":" "},{"$f":"IF(C37>0,G37/SUM(C37+E37+F37),IF(C37=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C27++C29+C32+C35+C37","v":0},null,{"$f":"E27+E29+E32+E35+E37","v":0},{"$f":"F27+F29+F32+F35+F37","v":0},{"$f":"G27+G29+G32+G35+G37","v":0}]
[null,null,null,null,{"$f":"IF(C39=0,0,E39/C39)","v":0},{"$f":"IF(C39=0,0,F39/SUM(C39+E39))","v":0},{"$f":"IF(C39=0,0,G39/SUM(C39+E39+F39))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)"]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C41=0,0,C39/C41)","v":0},null,{"$f":"IF(C41=0,0,E39/C41)","v":0},{"$f":"IF(C41=0,0,F39/C41)","v":0},{"$f":"IF(C41=0,0,G39/C41)","v":0}]
[null,null,null,null,{"$f":"IF(C42=0,0,E42/C42)","v":0},{"$f":"IF(C42=0,0,F42/SUM(C42+E42))","v":0},{"$f":"IF(C42=0,0,G42/SUM(C42+E42+F42))","v":0}]
[]
[]
["Impact on Other Funds (unhide page 4s using buttons on bottom of page 1a)"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E26","v":0},{"$f":"+F26","v":{"$error":"#N/A"}},{"$f":"+G26","v":{"$error":"#N/A"}}]
["Y/N","Adult Education Fund",null,null,null,null,null,null,{"$f":"IF(A49=\"Yes\",\"Optional- click on the link in cell B50 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Child Development Fund",null,null,null,null,null,null,{"$f":"IF(A50=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Cafeteria Fund",null,null,null,null,null,null,{"$f":"IF(A51=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Enterprise Fund",null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
["Y/N","Other Fund ",null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2013-14","2014-15","2015-16"]
[null,null,null,null,"2014-15","2015-16","2016-17"]
[null,null,null,null,"2015-16","2016-17","2017-18"]
[null,null,null,null,"2016-17","2017-18","2018-19"]
[null,null,null,null,"2017-18","2018-19","2019-20"]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E120","v":"2026-27"},{"$f":"+E121","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E121","v":"2027-28"},{"$f":"+E122","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Page 1 Total - All Agreements","index":7,"n_rows":106,"n_cols":9,"rows_kept":106,"cut":false,"hidden":false,"merged":[[17,2,17,3],[6,0,6,6],[7,0,7,6],[8,0,8,1],[8,4,10,6],[9,0,9,1],[11,0,12,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,0,16,0],[34,0,35,1],[35,2,35,3],[18,0,19,0],[20,2,20,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[3,0,3,1],[3,2,3,6],[10,0,10,1],[5,0,5,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6]]}
["PUBLIC DISCLOSURE OF PROPOSED COLLECTIVE BARGAINING AGREEMENT"]
["in accordance with AB 1200 (Chapter 1213/Statutes 1991), AB 2756 (Chapter 52/Statutes 2004), GC 3547.5"]
[]
["Name of School District:",null,{"$f":"'Page 1a, Cost of the agreement'!$C$4","v":0}]
["Total of all costs entered in Page 1a - Page 1e"]
[]
[]
["A.  Total Proposed Change in Compensation"]
[null,null,null,null,"Fiscal Impact of Proposed Agreement                                             (Complete Years 2 and 3 for ongoing costs, multiyear and overlapping agreements)"]
["Bargaining Unit Compensation",null,null,"Fiscal Impact of Proposed Agreement"]
[]
["Fund 01- General Fund",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"'Page 1a, Cost of the agreement'!E27","v":0},{"$f":"VLOOKUP($E13,$E$93:$G$104,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($E13,$E$93:$G$104,3)","v":{"$error":"#N/A"}}]
["1.","Salary Schedule                                                           ",{"$f":"'Page 1a, Cost of the agreement'!C28+'Page 1b, Other Agreement 1'!C28+'Page 1c, Other Agreement 2'!C28+'Page 1d, Other Agreement 3'!C27+'Page 1e, Other Agreement 4'!C27","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E28+'Page 1b, Other Agreement 1'!E28+'Page 1c, Other Agreement 2'!E28+'Page 1d, Other Agreement 3'!E27+'Page 1e, Other Agreement 4'!E27","v":0},{"$f":"'Page 1a, Cost of the agreement'!F28+'Page 1b, Other Agreement 1'!F28+'Page 1c, Other Agreement 2'!F28+'Page 1d, Other Agreement 3'!F27+'Page 1e, Other Agreement 4'!F27","v":0},{"$f":"'Page 1a, Cost of the agreement'!G28+'Page 1b, Other Agreement 1'!G28+'Page 1c, Other Agreement 2'!G28+'Page 1d, Other Agreement 3'!G27+'Page 1e, Other Agreement 4'!G27","v":0}]
[null,"On-Schedule increase",null,null,{"$f":"IF($C$14>0,E14/C14,IF($C$14=0,\"\"))","v":""},{"$f":"IF($C$14>0,F14/(C14+E14),IF($C$14=0,\"\"))","v":""},{"$f":"IF($C$14>0,G14/(C14+E14+F14),IF($C$14=0,\"\"))","v":""}]
["2.","Step & Column",{"$f":"'Page 1a, Cost of the agreement'!C30+'Page 1b, Other Agreement 1'!C30+'Page 1c, Other Agreement 2'!C30+'Page 1d, Other Agreement 3'!C29+'Page 1e, Other Agreement 4'!C29","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E30+'Page 1b, Other Agreement 1'!E30+'Page 1c, Other Agreement 2'!E30+'Page 1d, Other Agreement 3'!E29+'Page 1e, Other Agreement 4'!E29","v":0},{"$f":"'Page 1a, Cost of the agreement'!F30+'Page 1b, Other Agreement 1'!F30+'Page 1c, Other Agreement 2'!F30+'Page 1d, Other Agreement 3'!F29+'Page 1e, Other Agreement 4'!F29","v":0},{"$f":"'Page 1a, Cost of the agreement'!G30+'Page 1b, Other Agreement 1'!G30+'Page 1c, Other Agreement 2'!G30+'Page 1d, Other Agreement 3'!G29+'Page 1e, Other Agreement 4'!G29","v":0}]
[null,"Increase or decrease in the cost of step & column as a result of the settlement"]
[null,null,null,null,{"$f":"IF(C16>0,E16/C16,IF(C16=0,\" \"))","v":" "},{"$f":"IF(C16>0,F16/SUM(C16+E16),IF(C16=0,\" \"))","v":" "},{"$f":"IF(C16>0,G16/SUM(C16+E16+F16),IF(C16=0,\" \"))","v":" "}]
["3.","Other Compensation ",{"$f":"'Page 1a, Cost of the agreement'!C33+'Page 1b, Other Agreement 1'!C33+'Page 1c, Other Agreement 2'!C33+'Page 1d, Other Agreement 3'!C32+'Page 1e, Other Agreement 4'!C32","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E33+'Page 1b, Other Agreement 1'!E33+'Page 1c, Other Agreement 2'!E33+'Page 1d, Other Agreement 3'!E32+'Page 1e, Other Agreement 4'!E32","v":0},{"$f":"'Page 1a, Cost of the agreement'!F33+'Page 1b, Other Agreement 1'!F33+'Page 1c, Other Agreement 2'!F33+'Page 1d, Other Agreement 3'!F32+'Page 1e, Other Agreement 4'!F32","v":0},{"$f":"'Page 1a, Cost of the agreement'!G33+'Page 1b, Other Agreement 1'!G33+'Page 1c, Other Agreement 2'!G33+'Page 1d, Other Agreement 3'!G32+'Page 1e, Other Agreement 4'!G32","v":0}]
[null,"Stipends, Off-schedule payments, Longevity, Overtime, Differential, one-time bonuses, etc."]
[null,null,null,null,{"$f":"IF(C19>0,E19/C19,IF(C19=0,\" \"))","v":" "},{"$f":"IF(C19>0,F19/SUM(C19+E19),IF(C19=0,\" \"))","v":" "},{"$f":"IF(C19>0,G19/SUM(C19+E19+F19),IF(C19=0,\" \"))","v":" "}]
["4.","Statutory Benefits - STRS, PERS, FICA, WC, UI, Medicare, etc.",{"$f":"'Page 1a, Cost of the agreement'!C36+'Page 1b, Other Agreement 1'!C36+'Page 1c, Other Agreement 2'!C36+'Page 1d, Other Agreement 3'!C35+'Page 1e, Other Agreement 4'!C35","v":0},{"$f":"(D14+D19)*20.97%","v":0},{"$f":"'Page 1a, Cost of the agreement'!E36+'Page 1b, Other Agreement 1'!E36+'Page 1c, Other Agreement 2'!E36+'Page 1d, Other Agreement 3'!E35+'Page 1e, Other Agreement 4'!E35","v":0},{"$f":"'Page 1a, Cost of the agreement'!F36+'Page 1b, Other Agreement 1'!F36+'Page 1c, Other Agreement 2'!F36+'Page 1d, Other Agreement 3'!F35+'Page 1e, Other Agreement 4'!F35","v":0},{"$f":"'Page 1a, Cost of the agreement'!G36+'Page 1b, Other Agreement 1'!G36+'Page 1c, Other Agreement 2'!G36+'Page 1d, Other Agreement 3'!G35+'Page 1e, Other Agreement 4'!G35","v":0}]
[null,null,null,null,{"$f":"IF(C22=0,0,E22/C22)","v":0},{"$f":"IF(C22=0,0,F22/SUM(C22+E22))","v":0},{"$f":"IF(C22=0,0,G22/SUM(C22+E22+F22))","v":0}]
["5.","Health/Welfare Plans ",{"$f":"'Page 1a, Cost of the agreement'!C38+'Page 1b, Other Agreement 1'!C38+'Page 1c, Other Agreement 2'!C38+'Page 1d, Other Agreement 3'!C37+'Page 1e, Other Agreement 4'!C37","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E38+'Page 1b, Other Agreement 1'!E38+'Page 1c, Other Agreement 2'!E38+'Page 1d, Other Agreement 3'!E37+'Page 1e, Other Agreement 4'!E37","v":0},{"$f":"'Page 1a, Cost of the agreement'!F38+'Page 1b, Other Agreement 1'!F38+'Page 1c, Other Agreement 2'!F38+'Page 1d, Other Agreement 3'!F37+'Page 1e, Other Agreement 4'!F37","v":0},{"$f":"'Page 1a, Cost of the agreement'!G38+'Page 1b, Other Agreement 1'!G38+'Page 1c, Other Agreement 2'!G38+'Page 1d, Other Agreement 3'!G37+'Page 1e, Other Agreement 4'!G37","v":0}]
[null,null,null,null,{"$f":"IF(C24>0,E24/C24,IF(C24=0,\" \"))","v":" "},{"$f":"IF(C24>0,F24/SUM(C24+E24),IF(C24=0,\" \"))","v":" "},{"$f":"IF(C24>0,G24/SUM(C24+E24+F24),IF(C24=0,\" \"))","v":" "}]
["6.","Total Bargaining Unit Compensation                                   Add Items 1 through 5 to equal 6",{"$f":"C14+C16+C19+C22+C24","v":0},null,{"$f":"E14+E16+E19+E22+E24","v":0},{"$f":"F14+F16+F19+F22+F24","v":0},{"$f":"G14+G16+G19+G22+G24","v":0}]
[null,null,null,null,{"$f":"IF(C26=0,0,E26/C26)","v":0},{"$f":"IF(C26=0,0,F26/SUM(C26+E26))","v":0},{"$f":"IF(C26=0,0,G26/SUM(C26+E26+F26))","v":0}]
["7.","Total Number of Bargaining Unit Employees (Use FTEs if appropriate)",{"$f":"'Page 1a, Cost of the agreement'!C42+'Page 1b, Other Agreement 1'!C42+'Page 1c, Other Agreement 2'!C42","v":0}]
["8.","Total Compensation Average Cost per Bargaining Unit Employee ",{"$f":"IF(C28=0,0,C26/C28)","v":0},null,{"$f":"IF(C28=0,0,E26/C28)","v":0},{"$f":"IF(C28=0,0,F26/C28)","v":0},{"$f":"IF(C28=0,0,G26/C28)","v":0}]
[null,null,null,null,{"$f":"IF(C29=0,0,E29/C29)","v":0},{"$f":"IF(C29=0,0,F29/SUM(C29+E29))","v":0},{"$f":"IF(C29=0,0,G29/SUM(C29+E29+F29))","v":0}]
[]
[]
[]
["Impact on Other Funds"]
["Will this agreement have an impact on any other funds?  ",null,"Annual Cost Prior to Proposed Settlement",null,"Year 1            Increase/(Decrease)","Year 2            Increase/(Decrease)","Year 3            Increase/(Decrease)"]
[null,null,null,null,{"$f":"+E13","v":0},{"$f":"+F13","v":{"$error":"#N/A"}},{"$f":"+G13","v":{"$error":"#N/A"}}]
[null,"Adult Education Fund",{"$f":"'Page 1a, Cost of the agreement'!C52+'Page 1b, Other Agreement 1'!C50+'Page 1c, Other Agreement 2'!C50+'Page 1d, Other Agreement 3'!C49+'Page 1e, Other Agreement 4'!C49","v":0},{"$f":"'Page 1a, Cost of the agreement'!D52+'Page 1b, Other Agreement 1'!D50+'Page 1c, Other Agreement 2'!D50","v":0},{"$f":"'Page 1a, Cost of the agreement'!E52+'Page 1b, Other Agreement 1'!E50+'Page 1c, Other Agreement 2'!E50+'Page 1d, Other Agreement 3'!E49+'Page 1e, Other Agreement 4'!E49","v":0},{"$f":"'Page 1a, Cost of the agreement'!F52+'Page 1b, Other Agreement 1'!F50+'Page 1c, Other Agreement 2'!F50+'Page 1d, Other Agreement 3'!F49+'Page 1e, Other Agreement 4'!F49","v":0},{"$f":"'Page 1a, Cost of the agreement'!G52+'Page 1b, Other Agreement 1'!G50+'Page 1c, Other Agreement 2'!G50+'Page 1d, Other Agreement 3'!G49+'Page 1e, Other Agreement 4'!G49","v":0},null,{"$f":"IF(A37=\"Yes\",\"Optional- click on the link in cell B52 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[null,"Child Development Fund",{"$f":"'Page 1a, Cost of the agreement'!C53+'Page 1b, Other Agreement 1'!C51+'Page 1c, Other Agreement 2'!C51+'Page 1d, Other Agreement 3'!C50+'Page 1e, Other Agreement 4'!C50","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E53+'Page 1b, Other Agreement 1'!E51+'Page 1c, Other Agreement 2'!E51+'Page 1d, Other Agreement 3'!E50+'Page 1e, Other Agreement 4'!E50","v":0},{"$f":"'Page 1a, Cost of the agreement'!F53+'Page 1b, Other Agreement 1'!F51+'Page 1c, Other Agreement 2'!F51+'Page 1d, Other Agreement 3'!F50+'Page 1e, Other Agreement 4'!F50","v":0},{"$f":"'Page 1a, Cost of the agreement'!G53+'Page 1b, Other Agreement 1'!G51+'Page 1c, Other Agreement 2'!G51+'Page 1d, Other Agreement 3'!G50+'Page 1e, Other Agreement 4'!G50","v":0},null,{"$f":"IF(A38=\"Yes\",\"Optional- click on the link in cell B53 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[null,"Cafeteria Fund",{"$f":"'Page 1a, Cost of the agreement'!C54+'Page 1b, Other Agreement 1'!C52+'Page 1c, Other Agreement 2'!C52+'Page 1d, Other Agreement 3'!C51+'Page 1e, Other Agreement 4'!C51","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E54+'Page 1b, Other Agreement 1'!E52+'Page 1c, Other Agreement 2'!E52+'Page 1d, Other Agreement 3'!E51+'Page 1e, Other Agreement 4'!E51","v":0},{"$f":"'Page 1a, Cost of the agreement'!F54+'Page 1b, Other Agreement 1'!F52+'Page 1c, Other Agreement 2'!F52+'Page 1d, Other Agreement 3'!F51+'Page 1e, Other Agreement 4'!F51","v":0},{"$f":"'Page 1a, Cost of the agreement'!G54+'Page 1b, Other Agreement 1'!G52+'Page 1c, Other Agreement 2'!G52+'Page 1d, Other Agreement 3'!G51+'Page 1e, Other Agreement 4'!G51","v":0},null,{"$f":"IF(A39=\"Yes\",\"Optional- click on the link in cell B54 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[null,"Other Enterprise Fund",{"$f":"'Page 1a, Cost of the agreement'!C55+'Page 1b, Other Agreement 1'!C53+'Page 1c, Other Agreement 2'!C53+'Page 1d, Other Agreement 3'!C52+'Page 1e, Other Agreement 4'!C52","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E55+'Page 1b, Other Agreement 1'!E53+'Page 1c, Other Agreement 2'!E53+'Page 1d, Other Agreement 3'!E52+'Page 1e, Other Agreement 4'!E52","v":0},{"$f":"'Page 1a, Cost of the agreement'!F55+'Page 1b, Other Agreement 1'!F53+'Page 1c, Other Agreement 2'!F53+'Page 1d, Other Agreement 3'!F52+'Page 1e, Other Agreement 4'!F52","v":0},{"$f":"'Page 1a, Cost of the agreement'!G55+'Page 1b, Other Agreement 1'!G53+'Page 1c, Other Agreement 2'!G53+'Page 1d, Other Agreement 3'!G52+'Page 1e, Other Agreement 4'!G52","v":0},null,{"$f":"IF(A40=\"Yes\",\"Optional- click on the link in cell B55 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[null,"Other Fund ",{"$f":"'Page 1a, Cost of the agreement'!C56+'Page 1b, Other Agreement 1'!C54+'Page 1c, Other Agreement 2'!C54+'Page 1d, Other Agreement 3'!C53+'Page 1e, Other Agreement 4'!C53","v":0},null,{"$f":"'Page 1a, Cost of the agreement'!E56+'Page 1b, Other Agreement 1'!E54+'Page 1c, Other Agreement 2'!E54+'Page 1d, Other Agreement 3'!E53+'Page 1e, Other Agreement 4'!E53","v":0},{"$f":"'Page 1a, Cost of the agreement'!F56+'Page 1b, Other Agreement 1'!F54+'Page 1c, Other Agreement 2'!F54+'Page 1d, Other Agreement 3'!F53+'Page 1e, Other Agreement 4'!F53","v":0},{"$f":"'Page 1a, Cost of the agreement'!G56+'Page 1b, Other Agreement 1'!G54+'Page 1c, Other Agreement 2'!G54+'Page 1d, Other Agreement 3'!G53+'Page 1e, Other Agreement 4'!G53","v":0},null,{"$f":"IF(A41=\"Yes\",\"Optional- click on the link in cell B56 to complete a separate disclosure form for this fund\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Certificated"]
[null,null,null,null,"Classified"]
[null,null,null,null,"Management/Confidential"]
[null,null,null,null,"Other"]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]
[null,null,null,null,"N/A"]
[null,null,null,null,"Y/N"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2018-19","2019-20","2020-21"]
[null,null,null,null,"2019-20","2020-21","2021-22"]
[null,null,null,null,"2020-21","2021-22","2022-23"]
[null,null,null,null,"2021-22","2022-23","2023-24"]
[null,null,null,null,"2022-23","2023-24","2024-25"]
[null,null,null,null,"2023-24","2024-25","2025-26"]
[null,null,null,null,"2024-25","2025-26","2026-27"]
[null,null,null,null,"2025-26",{"$f":"+E101","v":"2026-27"},{"$f":"+E102","v":"2027-28"}]
[null,null,null,null,"2026-27",{"$f":"+E102","v":"2027-28"},{"$f":"+E103","v":"2028-29"}]
[null,null,null,null,"2027-28","2028-29","2029-30"]
[null,null,null,null,"2028-29","2029-30","2030-31"]
[null,null,null,null,"2029-30","2030-31","2031-32"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]

{"sheet":"Page 2, Explanations","index":8,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,1,23,14],[25,1,25,4],[25,6,25,7],[25,9,25,10],[26,1,26,4],[26,6,26,7],[26,9,26,10],[10,1,10,14],[11,1,11,14],[12,1,12,14],[13,1,13,14],[14,1,14,14],[5,1,5,14],[6,1,6,14],[7,1,7,14],[8,1,8,14],[9,1,9,14],[20,1,20,14],[21,1,21,9],[15,1,15,14],[16,1,16,14],[17,1,17,14],[4,1,4,14],[2,1,2,14],[3,1,3,14],[1,1,1,14],[0,1,0,14]]}
[null,{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
[null," 9.  Provide a brief narrative of the proposed change in compensation, including percentage "]
[null,"       change(s), effective date(s), and other comments and explanations as necessary."]
[]
[]
[]
[null,"10.  Were any additional steps, columns, or ranges added to the salary schedules?  (If yes, please explain.)"]
[]
[]
[]
["B.","Proposed Negotiated Changes in Non-Compensation items (class size adjustments, staff development days, teacher prep time, etc. )"]
[]
[]
[]
[]
["C.","What are the specific impacts on instructional and support programs to accommodate the settlement?  Include the impact of changes such as staff reductions or increases, program reductions or increases, elimination or expansion of other services or programs (i.e., counselors, librarians, custodial staff, etc.)"]
[]
[]
[]
[null,"Will the increase in costs as a result of the agreement necessitate budget reductions in the current or "]
[null,"subsequent two fiscal years? "]
[]
[null,"       If yes, please specify the amount of the budget reductions necessary for each fiscal year"]
[]
[null,{"$f":"+'Page 1a, Cost of the agreement'!E27","v":0},null,null,null,null,{"$f":"+'Page 1a, Cost of the agreement'!F27","v":{"$error":"#VALUE!"}},null,null,{"$f":"+'Page 1a, Cost of the agreement'!G27","v":{"$error":"#VALUE!"}}]

{"sheet":"Page 3 Explanations","index":9,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[24,1,24,10],[18,1,18,10],[19,1,19,10],[20,1,20,10],[21,1,21,10],[22,1,22,10],[23,1,23,10],[17,1,17,10],[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,1,14,10],[15,1,15,10],[16,1,16,10],[5,1,5,14],[0,1,0,10],[1,1,1,10],[2,1,2,10],[3,1,3,14],[4,1,4,10]]}
[null,{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[null,{"$f":"IF('Page 1a, Cost of the agreement'!C5=0,\" \",'Page 1a, Cost of the agreement'!C5)","v":" "}]
[]
[{"$f":"\"D.\"","v":"D."},"What contingency language is included in the proposed agreement (e.g., reopeners, etc.)?"]
[]
[]
[]
["E.","Identify other major provisions that do not directly affect the district's costs, such as binding arbitrations, grievance procedures, etc."]
[]
[]
[]
["F.","Source of Funding for Proposed Agreement:"]
[null,"1.  Current Year"]
[]
[]
[]
[null,"2.  If this is a single year agreement, how will the ongoing cost of the proposed agreement be funded in "]
[null,"     subsequent years?"]
[]
[]
[]
[null,"3.  If this is a multiyear agreement, what is the source of funding, including assumptions used, to fund these"]
[null,"     obligations in subsequent years?  (Remember to include compounding effects in meeting obligations.)"]

{"sheet":"Page 4a, Unrest GF","index":10,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,2,40,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[8,0,8,1],[13,0,13,1],[14,0,14,1],[23,0,23,1],[24,0,24,1],[28,0,28,1],[32,0,32,1],[33,0,33,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"Section G, Pages 4a through 4i:  Impact of Proposed Agreement on Current-Year Operating Budget"]
[null,null,null,null,null,null,null,"for General, Adult Education, Child Development, Cafeteria and Other Funds"]
[null,null,"Unrestricted General Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4"]
[null,"Object Code","Latest Board-Approved Budget Before Settlement  (As of xxxxxx) ","Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) "]
["REVENUES"]
["     LCFF Revenue","8010-8099",{"$f":"'Page 5a MYP Unrest GF'!K9+'Page 5a MYP Unrest GF'!S9","v":0},null,null,{"$f":"C10+E10","v":0}]
["     Federal Revenue","8100-8299",{"$f":"'Page 5a MYP Unrest GF'!K10+'Page 5a MYP Unrest GF'!S10","v":0},null,null,{"$f":"C11+E11","v":0}]
["     Other State Revenue","8300-8599",{"$f":"'Page 5a MYP Unrest GF'!K11+'Page 5a MYP Unrest GF'!S11","v":0},null,null,{"$f":"C12+E12","v":0}]
["     Other Local Revenue","8600-8799",{"$f":"'Page 5a MYP Unrest GF'!K12+'Page 5a MYP Unrest GF'!S12","v":0},null,null,{"$f":"C13+E13","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},null,{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":0}]
["EXPENDITURES"]
["     Certificated Salaries ","1000-1999",{"$f":"'Page 5a MYP Unrest GF'!K24+'Page 5a MYP Unrest GF'!S24","v":0},null,null,{"$f":"C16+D16+E16","v":0}]
["     Classified Salaries","2000-2999",{"$f":"'Page 5a MYP Unrest GF'!K30+'Page 5a MYP Unrest GF'!S30","v":0},null,null,{"$f":"C17+D17+E17","v":0}]
["     Employee Benefits","3000-3999",{"$f":"'Page 5a MYP Unrest GF'!K31+'Page 5a MYP Unrest GF'!S31","v":0},null,null,{"$f":"C18+D18+E18","v":0}]
["     Books and Supplies","4000-4999",{"$f":"'Page 5a MYP Unrest GF'!K32+'Page 5a MYP Unrest GF'!S32","v":0},null,null,{"$f":"C19+E19","v":0}]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"'Page 5a MYP Unrest GF'!K33+'Page 5a MYP Unrest GF'!S33","v":0},null,null,{"$f":"C20+E20","v":0}]
["     Capital Outlay","6000-6999",{"$f":"'Page 5a MYP Unrest GF'!K34+'Page 5a MYP Unrest GF'!S34","v":0},null,null,{"$f":"C21+E21","v":0}]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",{"$f":"'Page 5a MYP Unrest GF'!K35+'Page 5a MYP Unrest GF'!S35","v":0},null,null,{"$f":"C22+E22","v":0}]
["     Transfers of Indirect Costs","7300-7399",{"$f":"'Page 5a MYP Unrest GF'!K36+'Page 5a MYP Unrest GF'!S36","v":0},null,null,{"$f":"C23+E23","v":0}]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["     Transfers In and Other Sources","8900-8979",{"$f":"'Page 5a MYP Unrest GF'!K14+'Page 5a MYP Unrest GF'!K15+'Page 5a MYP Unrest GF'!S14+'Page 5a MYP Unrest GF'!S15","v":0},null,null,{"$f":"C26+D26+E26","v":0}]
["     Transfers Out and Other Uses","7600-7699",{"$f":"'Page 5a MYP Unrest GF'!K38+'Page 5a MYP Unrest GF'!K39+'Page 5a MYP Unrest GF'!S38+'Page 5a MYP Unrest GF'!S39","v":0},null,null,{"$f":"C27+D27+E27","v":0}]
["     Contributions","8980-8999",{"$f":"'Page 5a MYP Unrest GF'!K16+'Page 5a MYP Unrest GF'!S16","v":0},null,null,{"$f":"C28+D28+E28","v":0}]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C24+C26-C27+C28","v":0},{"$f":"D14-D24+D26-D27+D28","v":0},{"$f":"E14-E24+E26-E27+E28","v":0},{"$f":"F14-F24+F26-F27+F28","v":0}]
[]
["BEGINNING FUND BALANCE ",9791,{"$f":"'Page 5a MYP Unrest GF'!K44+'Page 5a MYP Unrest GF'!S45","v":0},null,null,{"$f":"C31","v":0}]
["    Audit Adjustments/Other Restatements","9793/9795",null,null,null,{"$f":"C32","v":0}]
["ENDING FUND BALANCE ",null,{"$f":"C29+C31+C32","v":0},{"$f":"D29","v":0},{"$f":"E29","v":0},{"$f":"F29+F31+F32","v":0}]
["COMPONENTS OF ENDING FUND BALANCE:"]
["     Nonspendable ","9711-9719",{"$f":"'Page 5a MYP Unrest GF'!K47+'Page 5a MYP Unrest GF'!S48","v":0},null,null,{"$f":"C35+D35+E35","v":0}]
["     Restricted",9740]
["     Committed ","9750-9760",{"$f":"'Page 5a MYP Unrest GF'!K50+'Page 5a MYP Unrest GF'!K51+'Page 5a MYP Unrest GF'!S51+'Page 5a MYP Unrest GF'!S52","v":0},null,null,{"$f":"C37+D37+E37","v":0}]
["     Assigned ",9780,{"$f":"'Page 5a MYP Unrest GF'!K52+'Page 5a MYP Unrest GF'!S53","v":0},null,null,{"$f":"C38+D38+E38","v":0}]
["     Reserve for Economic Uncertainties",9789,{"$f":"'Page 5a MYP Unrest GF'!K60+'Page 5a MYP Unrest GF'!S62","v":0},null,null,{"$f":"C39+D39+E39","v":0}]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C33-SUM(C35:C39)","v":0},{"$f":"D33-SUM(D35:D39)","v":0},{"$f":"E33-SUM(E35:E39)","v":0},{"$f":"F33-SUM(F35:F39)","v":0}]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE:  9790 amounts in Columns 1 and 4 must be positive"]

{"sheet":"Page 4b. Rest GF","index":11,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[24,0,24,1],[28,0,28,1],[32,0,32,1],[33,0,33,1],[40,2,40,5],[23,0,23,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[8,0,8,1],[13,0,13,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"Section G, Pages 4a through 4i:  Impact of Proposed Agreement on Current-Year Operating Budget"]
[null,null,null,null,null,null,null,"for General, Adult Education, Child Development, Cafeteria and Other Funds"]
[null,null,"Restricted General Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) "]
["REVENUES"]
["     LCFF Revenue","8010-8099",{"$f":"'Page 5b MYP Rest GF'!K9+'Page 5b MYP Rest GF'!S9","v":0},null,null,{"$f":"C10+E10","v":0}]
["     Federal Revenue","8100-8299",{"$f":"'Page 5b MYP Rest GF'!K10+'Page 5b MYP Rest GF'!S10","v":0},null,null,{"$f":"C11+E11","v":0}]
["     Other State Revenue","8300-8599",{"$f":"'Page 5b MYP Rest GF'!K11+'Page 5b MYP Rest GF'!S11","v":0},null,null,{"$f":"C12+E12","v":0}]
["     Other Local Revenue","8600-8799",{"$f":"'Page 5b MYP Rest GF'!K12+'Page 5b MYP Rest GF'!S12","v":0},null,null,{"$f":"C13+E13","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},null,{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":0}]
["EXPENDITURES"]
["     Certificated Salaries ","1000-1999",{"$f":"'Page 5b MYP Rest GF'!K24+'Page 5b MYP Rest GF'!S24","v":0},null,null,{"$f":"C16+D16+E16","v":0}]
["     Classified Salaries","2000-2999",{"$f":"'Page 5b MYP Rest GF'!K30+'Page 5b MYP Rest GF'!S30","v":0},null,null,{"$f":"C17+D17+E17","v":0}]
["     Employee Benefits","3000-3999",{"$f":"'Page 5b MYP Rest GF'!K31+'Page 5b MYP Rest GF'!S31","v":0},null,null,{"$f":"C18+D18+E18","v":0}]
["     Books and Supplies","4000-4999",{"$f":"'Page 5b MYP Rest GF'!K32+'Page 5b MYP Rest GF'!S32","v":0},null,null,{"$f":"C19+E19","v":0}]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"'Page 5b MYP Rest GF'!K33+'Page 5b MYP Rest GF'!S33","v":0},null,null,{"$f":"C20+E20","v":0}]
["     Capital Outlay","6000-6999",{"$f":"'Page 5b MYP Rest GF'!K34+'Page 5b MYP Rest GF'!S34","v":0},null,null,{"$f":"C21+E21","v":0}]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",{"$f":"'Page 5b MYP Rest GF'!K35+'Page 5b MYP Rest GF'!S35","v":0},null,null,{"$f":"C22+E22","v":0}]
["    Transfers of Indirect Costs","7300-7399",{"$f":"'Page 5b MYP Rest GF'!K36+'Page 5b MYP Rest GF'!S36","v":0},null,null,{"$f":"C23+E23","v":0}]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["     Transfers In and Other Sources","8900-8979",{"$f":"'Page 5b MYP Rest GF'!K14+'Page 5b MYP Rest GF'!K15+'Page 5b MYP Rest GF'!S14+'Page 5b MYP Rest GF'!S15","v":0},null,null,{"$f":"C26+D26+E26","v":0}]
["     Transfers Out and Other Uses","7600-7699",{"$f":"'Page 5b MYP Rest GF'!K38+'Page 5b MYP Rest GF'!K39+'Page 5b MYP Rest GF'!S38+'Page 5b MYP Rest GF'!S39","v":0},null,null,{"$f":"C27+D27+E27","v":0}]
["     Contributions","8980-8999",{"$f":"'Page 5b MYP Rest GF'!K16+'Page 5b MYP Rest GF'!S16","v":0},null,null,{"$f":"C28+D28+E28","v":0}]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C24+C26-C27+C28","v":0},{"$f":"D14-D24+D26-D27+D28","v":0},{"$f":"E14-E24+E26-E27+E28","v":0},{"$f":"F14-F24+F26-F27+F28","v":0}]
[]
["BEGINNING FUND BALANCE ",9791,{"$f":"'Page 5b MYP Rest GF'!K44+'Page 5b MYP Rest GF'!S45","v":0},null,null,{"$f":"C31","v":0}]
["    Audit Adjustments/Other Restatements","9793/9795",null,null,null,{"$f":"C32","v":0}]
["ENDING FUND BALANCE ",null,{"$f":"C29+C31+C32","v":0},{"$f":"D29","v":0},{"$f":"E29","v":0},{"$f":"F29+F31+F32","v":0}]
["COMPONENTS OF ENDING FUND BALANCE:"]
["     Nonspendable ","9711-9719",{"$f":"'Page 5b MYP Rest GF'!K47+'Page 5b MYP Rest GF'!S48","v":0},null,null,{"$f":"C35+D35+E35","v":0}]
["     Restricted ",9740,{"$f":"C33-C35","v":0},null,null,{"$f":"C36+D36+E36","v":0}]
["     Committed ","9750-9760"]
["     Assigned Amounts",9780]
["     Reserve for Economic Uncertainties",9789]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C33-SUM(C35:C39)","v":0},{"$f":"D33-SUM(D35:D39)","v":0},{"$f":"E33-SUM(E35:E39)","v":0},{"$f":"F33-SUM(F35:F39)","v":0}]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE:  9790 amounts in Columns 1 and 4 must be positive"]

{"sheet":"Page 4c Combined GF","index":12,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[23,0,23,1],[28,0,28,1],[32,0,32,1],[40,2,40,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[8,0,8,1],[13,0,13,1],[14,0,14,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET"]
[]
[null,null,"Combined General Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) "]
["REVENUES"]
["     LCFF Revenue","8010-8099",{"$f":"+'Page 4a, Unrest GF'!C10+'Page 4b. Rest GF'!C10","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E10+'Page 4b. Rest GF'!E10","v":0},{"$f":"C10+E10","v":0}]
["     Federal Revenue","8100-8299",{"$f":"+'Page 4a, Unrest GF'!C11+'Page 4b. Rest GF'!C11","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E11+'Page 4b. Rest GF'!E11","v":0},{"$f":"C11+E11","v":0}]
["     Other State Revenue","8300-8599",{"$f":"+'Page 4a, Unrest GF'!C12+'Page 4b. Rest GF'!C12","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E12+'Page 4b. Rest GF'!E12","v":0},{"$f":"C12+E12","v":0}]
["     Other Local Revenue","8600-8799",{"$f":"+'Page 4a, Unrest GF'!C13+'Page 4b. Rest GF'!C13","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E13+'Page 4b. Rest GF'!E13","v":0},{"$f":"C13+E13","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},null,{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":0}]
["EXPENDITURES"]
["     Certificated Salaries","1000-1999",{"$f":"+'Page 4a, Unrest GF'!C16+'Page 4b. Rest GF'!C16","v":0},{"$f":"+'Page 4a, Unrest GF'!D16+'Page 4b. Rest GF'!D16","v":0},{"$f":"+'Page 4a, Unrest GF'!E16+'Page 4b. Rest GF'!E16","v":0},{"$f":"C16+D16+E16","v":0}]
["     Classified Salaries","2000-2999",{"$f":"+'Page 4a, Unrest GF'!C17+'Page 4b. Rest GF'!C17","v":0},{"$f":"+'Page 4a, Unrest GF'!D17+'Page 4b. Rest GF'!D17","v":0},{"$f":"+'Page 4a, Unrest GF'!E17+'Page 4b. Rest GF'!E17","v":0},{"$f":"C17+D17+E17","v":0}]
["     Employee Benefits","3000-3999",{"$f":"+'Page 4a, Unrest GF'!C18+'Page 4b. Rest GF'!C18","v":0},{"$f":"+'Page 4a, Unrest GF'!D18+'Page 4b. Rest GF'!D18","v":0},{"$f":"+'Page 4a, Unrest GF'!E18+'Page 4b. Rest GF'!E18","v":0},{"$f":"C18+D18+E18","v":0}]
["     Books and Supplies","4000-4999",{"$f":"+'Page 4a, Unrest GF'!C19+'Page 4b. Rest GF'!C19","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E19+'Page 4b. Rest GF'!E19","v":0},{"$f":"C19+E19","v":0}]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"+'Page 4a, Unrest GF'!C20+'Page 4b. Rest GF'!C20","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E20+'Page 4b. Rest GF'!E20","v":0},{"$f":"C20+E20","v":0}]
["     Capital Outlay","6000-6999",{"$f":"+'Page 4a, Unrest GF'!C21+'Page 4b. Rest GF'!C21","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E21+'Page 4b. Rest GF'!E21","v":0},{"$f":"C21+E21","v":0}]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",{"$f":"+'Page 4a, Unrest GF'!C22+'Page 4b. Rest GF'!C22","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E22+'Page 4b. Rest GF'!E22","v":0},{"$f":"C22+E22","v":0}]
["    Transfers of Indirect Costs","7300-7399",{"$f":"+'Page 4a, Unrest GF'!C23+'Page 4b. Rest GF'!C23","v":0},null,{"$f":"+'Page 4a, Unrest GF'!E23+'Page 4b. Rest GF'!E23","v":0},{"$f":"C23+E23","v":0}]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0}]
["OTHER FINANCING SOURCES/USES"]
["     Transfer In and Other Sources","8900-8979",{"$f":"+'Page 4a, Unrest GF'!C26+'Page 4b. Rest GF'!C26","v":0},{"$f":"+'Page 4a, Unrest GF'!D26+'Page 4b. Rest GF'!D26","v":0},{"$f":"+'Page 4a, Unrest GF'!E26+'Page 4b. Rest GF'!E26","v":0},{"$f":"C26+D26+E26","v":0}]
["     Transfers Out and Other Uses","7600-7699",{"$f":"+'Page 4a, Unrest GF'!C27+'Page 4b. Rest GF'!C27","v":0},{"$f":"+'Page 4a, Unrest GF'!D27+'Page 4b. Rest GF'!D27","v":0},{"$f":"+'Page 4a, Unrest GF'!E27+'Page 4b. Rest GF'!E27","v":0},{"$f":"C27+D27+E27","v":0}]
["     Contributions","8980-8999",{"$f":"+'Page 4a, Unrest GF'!C28+'Page 4b. Rest GF'!C28","v":0},{"$f":"+'Page 4a, Unrest GF'!D28+'Page 4b. Rest GF'!D28","v":0},{"$f":"+'Page 4a, Unrest GF'!E28+'Page 4b. Rest GF'!E28","v":0},{"$f":"C28+D28+E28","v":0}]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C24+C26-C27+C28","v":0},{"$f":"D14-D24+D26-D27+D28","v":0},{"$f":"E14-E24+E26-E27+E28","v":0},{"$f":"F14-F24+F26-F27+F28","v":0}]
[]
["BEGINNING FUND BALANCE ",9791,{"$f":"+'Page 4a, Unrest GF'!C31+'Page 4b. Rest GF'!C31","v":0},null,null,{"$f":"C31","v":0}]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"+'Page 4a, Unrest GF'!C32+'Page 4b. Rest GF'!C32","v":0},null,null,{"$f":"C32","v":0}]
["ENDING FUND BALANCE ",null,{"$f":"C29+C31+C32","v":0},{"$f":"D29","v":0},{"$f":"E29","v":0},{"$f":"F29+F31+F32","v":0}]
["COMPONENTS OF ENDING FUND BALANCE:"]
["     Nonspendable ","9711-9719",{"$f":"+'Page 4a, Unrest GF'!C35+'Page 4b. Rest GF'!C35","v":0},{"$f":"+'Page 4a, Unrest GF'!D35+'Page 4b. Rest GF'!D35","v":0},{"$f":"+'Page 4a, Unrest GF'!E35+'Page 4b. Rest GF'!E35","v":0},{"$f":"C35+D35+E35","v":0}]
["     Restricted ",9740,{"$f":"+'Page 4b. Rest GF'!C36","v":0},{"$f":"+'Page 4b. Rest GF'!D36","v":0},{"$f":"+'Page 4a, Unrest GF'!E36+'Page 4b. Rest GF'!E36","v":0},{"$f":"C36+D36+E36","v":0}]
["     Committed ","9750-9760",{"$f":"+'Page 4a, Unrest GF'!C37","v":0},{"$f":"+'Page 4a, Unrest GF'!D37","v":0},{"$f":"+'Page 4a, Unrest GF'!E37+'Page 4b. Rest GF'!E37","v":0},{"$f":"C37+D37+E37","v":0}]
["     Assigned ",9780,{"$f":"+'Page 4a, Unrest GF'!C38","v":0},{"$f":"+'Page 4a, Unrest GF'!D38","v":0},{"$f":"+'Page 4a, Unrest GF'!E38+'Page 4b. Rest GF'!E38","v":0},{"$f":"C38+D38+E38","v":0}]
["     Reserve for Economic Uncertainties",9789,{"$f":"+'Page 4a, Unrest GF'!C39+'Page 4b. Rest GF'!C39","v":0},{"$f":"+'Page 4b. Rest GF'!D39+'Page 4a, Unrest GF'!D39","v":0},{"$f":"+'Page 4a, Unrest GF'!E39+'Page 4b. Rest GF'!E39","v":0},{"$f":"C39+D39+E39","v":0}]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C33-SUM(C35:C39)","v":0},{"$f":"D33-SUM(D35:D39)","v":0},{"$f":"E33-SUM(E35:E39)","v":0},{"$f":"F33-SUM(F35:F39)","v":0}]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive"]

{"sheet":"Page 4d Adult Education Fund","index":13,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[26,0,26,1],[31,0,31,1],[38,2,38,5],[13,0,13,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[8,0,8,1],[12,0,12,1],[7,14,7,22],[7,7,7,12],[2,7,5,22],[22,0,22,1],[23,0,23,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"To auto-populate the Latest Board Approved budget, export the fund to Excel from your latest SACS file.  Paste the Adopted budget in H9:M56, or paste the Interim Budget in O9:W57.  Do not paste in both, only paste the most recent board-approved budget and leave the other with zeros.  Only copy from SACS the lines shown in yellow - do not copy headers.  If SACS exports blanks for any line instead of zeros, manually enter a zero. Update formulas for Components of Ending Fund Balance as needed. Contact your DFA with questions."]
[]
[null,null,"Fund 11 - Adult Education Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,"Description","Resource Codes","Object Codes","XXXX-XX\nEstimated Actuals","XXXX-XX\nBudget","Percent\nDifference",null,"Description","Resource Codes","Object Codes","Original Budget\n(A)","Board Approved Operating Budget\n(B)","Actuals To Date\n(C)","Projected Year Totals\n(D)","Difference (Col B & D)\n(E)","% Diff Column B & D\n(F)"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) ",null,"Paste Adopted Excel Export from SACS Fund 11 here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,"OR","Paste Interim Excel Export from SACS Fund 11 here (description line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
["REVENUES",null,null,null,null,null,null,"1) LCFF Sources","","8010-8099",0,0,0,null,"1) LCFF Sources","","8010-8099",0,0,0,0,0,0]
["     Federal Revenue","8100-8299",{"$f":"L10+U10","v":0},null,null,{"$f":"C10+E10","v":0},null,"2) Federal Revenue","","8100-8299",0,0,0,null,"2) Federal Revenue","","8100-8299",0,0,0,0,0,0]
["     Other State Revenue","8300-8599",{"$f":"L11+U11","v":0},null,null,{"$f":"C11+E11","v":0},null,"3) Other State Revenue","","8300-8599",0,0,0,null,"3) Other State Revenue","","8300-8599",0,0,0,0,0,0]
["     Other Local Revenue","8600-8799",{"$f":"L12+U12","v":0},null,null,{"$f":"C12+E12","v":0},null,"4) Other Local Revenue","","8600-8799",0,0,0,null,"4) Other Local Revenue","","8600-8799",0,0,0,0,0,0]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},null,"5) TOTAL, REVENUES","","",0,0,0,null,"5) TOTAL, REVENUES","","",0,0,0,0,"",""]
["EXPENDITURES",null,null,null,null,null,null,"B. EXPENDITURES","","","","","",null,"B. EXPENDITURES","","","","","","","",""]
["     Certificated Salaries ","1000-1999",{"$f":"L15+U15","v":0},null,null,{"$f":"C15+D15+E15","v":0},null,"1) Certificated Salaries","","1000-1999",0,0,0,null,"1) Certificated Salaries","","1000-1999",0,0,0,0,0,0]
["     Classified Salaries","2000-2999",0,null,null,{"$f":"C16+D16+E16","v":0},null,"2) Classified Salaries","","2000-2999",0,0,0,null,"2) Classified Salaries","","2000-2999",0,0,0,0,0,0]
["     Employee Benefits","3000-3999",0,null,null,{"$f":"C17+D17+E17","v":0},null,"3) Employee Benefits","","3000-3999",0,0,0,null,"3) Employee Benefits","","3000-3999",0,0,0,0,0,0]
["     Books and Supplies","4000-4999",0,null,null,{"$f":"C18+E18","v":0},null,"4) Books and Supplies","","4000-4999",0,0,0,null,"4) Books and Supplies","","4000-4999",0,0,0,0,0,0]
["     Services and Other Operating Expenditures","5000-5999",0,null,null,{"$f":"C19+E19","v":0},null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,0,0,0]
["     Capital Outlay","6000-6999",0,null,null,{"$f":"C20+E20","v":0},null,"6) Capital Outlay","","6000-6999",0,0,0,null,"6) Capital Outlay","","6000-6999",0,0,0,0,0,0]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",0,null,null,{"$f":"C21+E21","v":0},null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299, 7400-7499",0,0,0,null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299,7400-7499",0,0,0,0,0,0]
["     Transfers of Indirect Costs","7300-7399",0,null,null,{"$f":"C22+E22","v":0},null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,0,0,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},null,"9) TOTAL, EXPENDITURES","","",0,0,0,null,"9) TOTAL, EXPENDITURES","","",0,0,0,0,"",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,0,"",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"L27+U27+L30+U30","v":0},null,null,{"$f":"C25+D25+E25","v":0},null,"D. OTHER FINANCING SOURCES/USES","","","","","",null,"D. OTHER FINANCING SOURCES/USES","","","","","","","",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"L28+U28+L31+U31","v":0},null,null,{"$f":"C26+D26+E26","v":0},null,"1) Interfund Transfers","","","","","",null,"1) Interfund Transfers","","","","","","","",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C13-C23+C25-C26","v":0},{"$f":"D13-D23+D25-D26","v":0},{"$f":"E13-E23+E25-E26","v":0},{"$f":"F13-F23+F25-F26","v":0},null,"a) Transfers In","","8900-8929",0,0,0,null,"a) Transfers In","","8900-8929",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"b) Transfers Out","","7600-7629",0,0,0,null,"b) Transfers Out","","7600-7629",0,0,0,0,0,0]
["BEGINNING FUND BALANCE ",9791,{"$f":"L37+U37","v":0},null,null,{"$f":"C29","v":0},null,"2) Other Sources/Uses","","","","","",null,"2) Other Sources/Uses","","","","","","","",""]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"L38+L40+U38+U40","v":0},null,null,{"$f":"C30","v":0},null,"a) Sources","","8930-8979",0,0,0,null,"a) Sources","","8930-8979",0,0,0,0,0,0]
["ENDING FUND BALANCE ",null,{"$f":"C27+C29+C30","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},{"$f":"F27+F29+F30","v":0},null,"b) Uses","","7630-7699",0,0,0,null,"b) Uses","","7630-7699",0,0,0,0,0,0]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,"3) Contributions","","8980-8999",0,0,0,null,"3) Contributions","","8980-8999",0,0,0,0,0,0]
["     Nonspendable ","9711-9719",{"$f":"L45+L46+L47+L48+U45+U46+U47+U48","v":0},null,null,{"$f":"C33+D33+E33","v":0},null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,0,"",""]
["     Restricted ",9740,{"$f":"L49+U49","v":0},null,null,{"$f":"C34+D34+E34","v":0},null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,0,"",""]
["     Committed ","9750-9760",{"$f":"L51+L52+U51+U52","v":0},null,null,{"$f":"C35+D35+E35","v":0},null,"F. FUND BALANCE, RESERVES","","","","","",null,"F. FUND BALANCE, RESERVES","","","","","","","",""]
["     Assigned ",9780,{"$f":"L54+U54","v":0},null,null,{"$f":"C36+D36+E36","v":0},null,"1) Beginning Fund Balance","","","","","",null,"1) Beginning Fund Balance","","","","","","","",""]
["     Reserve for Economic Uncertainties",9789,{"$f":"U56","v":0},null,null,{"$f":"C37+D37+E37","v":0},null,"a) As of July 1 - Unaudited","","9791",0,0,0,null,"a) As of July 1 - Unaudited","","9791",0,0,"",0,0,0]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C31-SUM(C33:C37)","v":0},{"$f":"D31-SUM(D33:D37)","v":0},{"$f":"E31-SUM(E33:E37)","v":0},{"$f":"F31-SUM(F33:F37)","v":0},null,"b) Audit Adjustments","","9793",0,0,0,null,"b) Audit Adjustments","","9793",0,0,"",0,0,0]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive",null,null,null,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,0,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Other Restatements","","9795",0,0,0,null,"d) Other Restatements","","9795",0,0,"",0,0,0]
[null,null,null,null,null,null,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,0,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,0,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Components of Ending Fund Balance","","","","","",null,"Components of Ending Fund Balance","","","","","","","",""]
[null,null,null,null,null,null,null,"a) Nonspendable","","","","","",null,"a) Nonspendable","","","","","","","",""]
[null,null,null,null,null,null,null,"Revolving Cash","","9711",0,0,0,null,"Revolving Cash","","9711",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Stores","","9712",0,0,0,null,"Stores","","9712",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Prepaid Items","","9713",0,0,0,null,"Prepaid Items","","9713",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"All Others","","9719",0,0,0,null,"All Others","","9719",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"b) Restricted","","9740",0,0,0,null,"b) Restricted","","9740",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"c) Committed","","","",0,"",null,"c) Committed","","","","","",0,"",""]
[null,null,null,null,null,null,null,"Stabilization Arrangements","","9750",0,0,0,null,"Stabilization Arrangements","","9750",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Other Commitments","","9760",0,0,0,null,"Other Commitments","","9760",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Assigned","","","","","",null,"d) Assigned","","","","","","","",""]
[null,null,null,null,null,null,null,"Other Assignments","","9780",0,0,0,null,"Other Assignments","","9780",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"e) Unassigned/Unappropriated Reserve for Economic Uncertainties","","9789",0,0,0,null,"e) Unassigned/Unappropriated","","","","","","","",""]
[null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,0,null,"Reserve for Economic Uncertainties","","9789",0,0,"",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,"",0,"",""]

{"sheet":"Page 4e Child Development Fund","index":14,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[22,0,22,1],[23,0,23,1],[26,0,26,1],[31,0,31,1],[38,2,38,5],[13,0,13,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,5,22],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[7,7,7,12],[7,14,7,22],[8,0,8,1],[12,0,12,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"To auto-populate the Latest Board Approved budget, export the fund to Excel from your latest SACS file.  Paste the Adopted budget in H9:M56, or paste the Interim Budget in O9:W57.  Do not paste in both, only paste the most recent board-approved budget and leave the other with zeros.  Only copy from SACS the lines shown in yellow - do not copy headers.  If SACS exports blanks for any line instead of zeros, manually enter a zero. Update formulas for Components of Ending Fund Balance as needed. Contact your DFA with questions."]
[]
[null,null,"Fund 12 - Child Development Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,"Description","Resource Codes","Object Codes","XXXX-XX\nEstimated Actuals","XXXX-XX\nBudget","Percent\nDifference",null,"Description","Resource Codes","Object Codes","Original Budget\n(A)","Board Approved Operating Budget\n(B)","Actuals To Date\n(C)","Projected Year Totals\n(D)","Difference (Col B & D)\n(E)","% Diff Column B & D\n(F)"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) ",null,"Paste Adopted Excel Export from SACS Fund 12 here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,"OR","Paste Interim Excel Export from SACS Fund 12 here (description line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
["REVENUES",null,null,null,null,null,null,"1) LCFF Sources","","8010-8099",0,0,0,null,"1) LCFF Sources","","8010-8099",0,0,0,0,0,0]
["     Federal Revenue","8100-8299",{"$f":"L10+U10","v":0},null,null,{"$f":"C10+E10","v":0},null,"2) Federal Revenue","","8100-8299",0,0,0,null,"2) Federal Revenue","","8100-8299",0,0,0,0,0,0]
["     Other State Revenue","8300-8599",{"$f":"L11+U11","v":0},null,null,{"$f":"C11+E11","v":0},null,"3) Other State Revenue","","8300-8599",0,0,0,null,"3) Other State Revenue","","8300-8599",0,0,0,0,0,0]
["     Other Local Revenue","8600-8799",{"$f":"L12+U12","v":0},null,null,{"$f":"C12+E12","v":0},null,"4) Other Local Revenue","","8600-8799",0,0,0,null,"4) Other Local Revenue","","8600-8799",0,0,0,0,0,0]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},null,"5) TOTAL, REVENUES","","",0,0,0,null,"5) TOTAL, REVENUES","","",0,0,0,0,"",""]
["EXPENDITURES",null,null,null,null,null,null,"B. EXPENDITURES","","","","","",null,"B. EXPENDITURES","","","","","","","",""]
["     Certificated Salaries ","1000-1999",{"$f":"L15+U15","v":0},null,null,{"$f":"C15+D15+E15","v":0},null,"1) Certificated Salaries","","1000-1999",0,0,0,null,"1) Certificated Salaries","","1000-1999",0,0,0,0,0,0]
["     Classified Salaries","2000-2999",0,null,null,{"$f":"C16+D16+E16","v":0},null,"2) Classified Salaries","","2000-2999",0,0,0,null,"2) Classified Salaries","","2000-2999",0,0,0,0,0,0]
["     Employee Benefits","3000-3999",0,null,null,{"$f":"C17+D17+E17","v":0},null,"3) Employee Benefits","","3000-3999",0,0,0,null,"3) Employee Benefits","","3000-3999",0,0,0,0,0,0]
["     Books and Supplies","4000-4999",0,null,null,{"$f":"C18+E18","v":0},null,"4) Books and Supplies","","4000-4999",0,0,0,null,"4) Books and Supplies","","4000-4999",0,0,0,0,0,0]
["     Services and Other Operating Expenditures","5000-5999",0,null,null,{"$f":"C19+E19","v":0},null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,0,0,0]
["     Capital Outlay","6000-6999",0,null,null,{"$f":"C20+E20","v":0},null,"6) Capital Outlay","","6000-6999",0,0,0,null,"6) Capital Outlay","","6000-6999",0,0,0,0,0,0]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",0,null,null,{"$f":"C21+E21","v":0},null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299, 7400-7499",0,0,0,null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299,7400-7499",0,0,0,0,0,0]
["     Transfers of Indirect Costs","7300-7399",0,null,null,{"$f":"C22+E22","v":0},null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,0,0,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},null,"9) TOTAL, EXPENDITURES","","",0,0,0,null,"9) TOTAL, EXPENDITURES","","",0,0,0,0,"",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,0,"",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"L27+U27+L30+U30","v":0},null,null,{"$f":"C25+D25+E25","v":0},null,"D. OTHER FINANCING SOURCES/USES","","","","","",null,"D. OTHER FINANCING SOURCES/USES","","","","","","","",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"L28+U28+L31+U31","v":0},null,null,{"$f":"C26+D26+E26","v":0},null,"1) Interfund Transfers","","","","","",null,"1) Interfund Transfers","","","","","","","",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C13-C23+C25-C26","v":0},{"$f":"D13-D23+D25-D26","v":0},{"$f":"E13-E23+E25-E26","v":0},{"$f":"F13-F23+F25-F26","v":0},null,"a) Transfers In","","8900-8929",0,0,0,null,"a) Transfers In","","8900-8929",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"b) Transfers Out","","7600-7629",0,0,0,null,"b) Transfers Out","","7600-7629",0,0,0,0,0,0]
["BEGINNING FUND BALANCE ",9791,{"$f":"L37+U37","v":0},null,null,{"$f":"C29","v":0},null,"2) Other Sources/Uses","","","","","",null,"2) Other Sources/Uses","","","","","","","",""]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"L38+L40+U38+U40","v":0},null,null,{"$f":"C30","v":0},null,"a) Sources","","8930-8979",0,0,0,null,"a) Sources","","8930-8979",0,0,0,0,0,0]
["ENDING FUND BALANCE ",null,{"$f":"C27+C29+C30","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},{"$f":"F27+F29+F30","v":0},null,"b) Uses","","7630-7699",0,0,0,null,"b) Uses","","7630-7699",0,0,0,0,0,0]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,"3) Contributions","","8980-8999",0,0,0,null,"3) Contributions","","8980-8999",0,0,0,0,0,0]
["     Nonspendable ","9711-9719",{"$f":"L45+L46+L47+L48+U45+U46+U47+U48","v":0},null,null,{"$f":"C33+D33+E33","v":0},null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,0,"",""]
["     Restricted ",9740,{"$f":"L49+U49","v":0},null,null,{"$f":"C34+D34+E34","v":0},null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,0,"",""]
["     Committed ","9750-9760",{"$f":"L51+L52+U51+U52","v":0},null,null,{"$f":"C35+D35+E35","v":0},null,"F. FUND BALANCE, RESERVES","","","","","",null,"F. FUND BALANCE, RESERVES","","","","","","","",""]
["     Assigned ",9780,{"$f":"L54+U54","v":0},null,null,{"$f":"C36+D36+E36","v":0},null,"1) Beginning Fund Balance","","","","","",null,"1) Beginning Fund Balance","","","","","","","",""]
["     Reserve for Economic Uncertainties",9789,{"$f":"U56","v":0},null,null,{"$f":"C37+D37+E37","v":0},null,"a) As of July 1 - Unaudited","","9791",0,0,0,null,"a) As of July 1 - Unaudited","","9791",0,0,"",0,0,0]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C31-SUM(C33:C37)","v":0},{"$f":"D31-SUM(D33:D37)","v":0},{"$f":"E31-SUM(E33:E37)","v":0},{"$f":"F31-SUM(F33:F37)","v":0},null,"b) Audit Adjustments","","9793",0,0,0,null,"b) Audit Adjustments","","9793",0,0,"",0,0,0]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive",null,null,null,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,0,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Other Restatements","","9795",0,0,0,null,"d) Other Restatements","","9795",0,0,"",0,0,0]
[null,null,null,null,null,null,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,0,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,0,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Components of Ending Fund Balance","","","","","",null,"Components of Ending Fund Balance","","","","","","","",""]
[null,null,null,null,null,null,null,"a) Nonspendable","","","","","",null,"a) Nonspendable","","","","","","","",""]
[null,null,null,null,null,null,null,"Revolving Cash","","9711",0,0,0,null,"Revolving Cash","","9711",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Stores","","9712",0,0,0,null,"Stores","","9712",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Prepaid Items","","9713",0,0,0,null,"Prepaid Items","","9713",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"All Others","","9719",0,0,0,null,"All Others","","9719",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"b) Restricted","","9740",0,0,0,null,"b) Restricted","","9740",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"c) Committed","","","",0,"",null,"c) Committed","","","","","",0,"",""]
[null,null,null,null,null,null,null,"Stabilization Arrangements","","9750",0,0,0,null,"Stabilization Arrangements","","9750",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Other Commitments","","9760",0,0,0,null,"Other Commitments","","9760",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Assigned","","","","","",null,"d) Assigned","","","","","","","",""]
[null,null,null,null,null,null,null,"Other Assignments","","9780",0,0,0,null,"Other Assignments","","9780",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"e) Unassigned/Unappropriated Reserve for Economic Uncertainties","","9789",0,0,0,null,"e) Unassigned/Unappropriated","","","","","","","",""]
[null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,0,null,"Reserve for Economic Uncertainties","","9789",0,0,"",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,"",0,"",""]

{"sheet":"Page 4f Cafeteria Fund","index":15,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[22,0,22,1],[23,0,23,1],[26,0,26,1],[31,0,31,1],[38,2,38,5],[13,0,13,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,5,22],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[7,7,7,12],[7,14,7,22],[8,0,8,1],[12,0,12,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"To auto-populate the Latest Board Approved budget, export the fund to Excel from your latest SACS file.  Paste the Adopted budget in H9:M56, or paste the Interim Budget in O9:W57.  Do not paste in both, only paste the most recent board-approved budget and leave the other with zeros.  Only copy from SACS the lines shown in yellow - do not copy headers.  If SACS exports blanks for any line instead of zeros, manually enter a zero. Update formulas for Components of Ending Fund Balance as needed. Contact your DFA with questions."]
[]
[null,null,"Fund 13 - Cafeteria Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,"Description","Resource Codes","Object Codes","XXXX-XX\nEstimated Actuals","XXXX-XX\nBudget","Percent\nDifference",null,"Description","Resource Codes","Object Codes","Original Budget\n(A)","Board Approved Operating Budget\n(B)","Actuals To Date\n(C)","Projected Year Totals\n(D)","Difference (Col B & D)\n(E)","% Diff Column B & D\n(F)"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) ",null,"Paste Adopted Excel Export from SACS Fund 13 here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,"OR","Paste Interim Excel Export from SACS Fund 13 here (description line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
["REVENUES",null,null,null,null,null,null,"1) LCFF Sources","","8010-8099",0,0,0,null,"1) LCFF Sources","","8010-8099",0,0,0,0,0,0]
["     Federal Revenue","8100-8299",{"$f":"L10+U10","v":0},null,null,{"$f":"C10+E10","v":0},null,"2) Federal Revenue","","8100-8299",0,0,0,null,"2) Federal Revenue","","8100-8299",0,0,0,0,0,0]
["     Other State Revenue","8300-8599",{"$f":"L11+U11","v":0},null,null,{"$f":"C11+E11","v":0},null,"3) Other State Revenue","","8300-8599",0,0,0,null,"3) Other State Revenue","","8300-8599",0,0,0,0,0,0]
["     Other Local Revenue","8600-8799",{"$f":"L12+U12","v":0},null,null,{"$f":"C12+E12","v":0},null,"4) Other Local Revenue","","8600-8799",0,0,0,null,"4) Other Local Revenue","","8600-8799",0,0,0,0,0,0]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},null,"5) TOTAL, REVENUES","","",0,0,0,null,"5) TOTAL, REVENUES","","",0,0,0,0,"",""]
["EXPENDITURES",null,null,null,null,null,null,"B. EXPENDITURES","","","","","",null,"B. EXPENDITURES","","","","","","","",""]
["     Certificated Salaries ","1000-1999",{"$f":"L15+U15","v":0},null,null,{"$f":"C15+D15+E15","v":0},null,"1) Certificated Salaries","","1000-1999",0,0,0,null,"1) Certificated Salaries","","1000-1999",0,0,0,0,0,0]
["     Classified Salaries","2000-2999",0,null,null,{"$f":"C16+D16+E16","v":0},null,"2) Classified Salaries","","2000-2999",0,0,0,null,"2) Classified Salaries","","2000-2999",0,0,0,0,0,0]
["     Employee Benefits","3000-3999",0,null,null,{"$f":"C17+D17+E17","v":0},null,"3) Employee Benefits","","3000-3999",0,0,0,null,"3) Employee Benefits","","3000-3999",0,0,0,0,0,0]
["     Books and Supplies","4000-4999",0,null,null,{"$f":"C18+E18","v":0},null,"4) Books and Supplies","","4000-4999",0,0,0,null,"4) Books and Supplies","","4000-4999",0,0,0,0,0,0]
["     Services and Other Operating Expenditures","5000-5999",0,null,null,{"$f":"C19+E19","v":0},null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,0,0,0]
["     Capital Outlay","6000-6999",0,null,null,{"$f":"C20+E20","v":0},null,"6) Capital Outlay","","6000-6999",0,0,0,null,"6) Capital Outlay","","6000-6999",0,0,0,0,0,0]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",0,null,null,{"$f":"C21+E21","v":0},null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299, 7400-7499",0,0,0,null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299,7400-7499",0,0,0,0,0,0]
["     Transfers of Indirect Costs","7300-7399",0,null,null,{"$f":"C22+E22","v":0},null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,0,0,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},null,"9) TOTAL, EXPENDITURES","","",0,0,0,null,"9) TOTAL, EXPENDITURES","","",0,0,0,0,"",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,0,"",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"L27+U27+L30+U30","v":0},null,null,{"$f":"C25+D25+E25","v":0},null,"D. OTHER FINANCING SOURCES/USES","","","","","",null,"D. OTHER FINANCING SOURCES/USES","","","","","","","",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"L28+U28+L31+U31","v":0},null,null,{"$f":"C26+D26+E26","v":0},null,"1) Interfund Transfers","","","","","",null,"1) Interfund Transfers","","","","","","","",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C13-C23+C25-C26","v":0},{"$f":"D13-D23+D25-D26","v":0},{"$f":"E13-E23+E25-E26","v":0},{"$f":"F13-F23+F25-F26","v":0},null,"a) Transfers In","","8900-8929",0,0,0,null,"a) Transfers In","","8900-8929",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"b) Transfers Out","","7600-7629",0,0,0,null,"b) Transfers Out","","7600-7629",0,0,0,0,0,0]
["BEGINNING FUND BALANCE ",9791,{"$f":"L37+U37","v":0},null,null,{"$f":"C29","v":0},null,"2) Other Sources/Uses","","","","","",null,"2) Other Sources/Uses","","","","","","","",""]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"L38+L40+U38+U40","v":0},null,null,{"$f":"C30","v":0},null,"a) Sources","","8930-8979",0,0,0,null,"a) Sources","","8930-8979",0,0,0,0,0,0]
["ENDING FUND BALANCE ",null,{"$f":"C27+C29+C30","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},{"$f":"F27+F29+F30","v":0},null,"b) Uses","","7630-7699",0,0,0,null,"b) Uses","","7630-7699",0,0,0,0,0,0]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,"3) Contributions","","8980-8999",0,0,0,null,"3) Contributions","","8980-8999",0,0,0,0,0,0]
["     Nonspendable ","9711-9719",{"$f":"L45+L46+L47+L48+U45+U46+U47+U48","v":0},null,null,{"$f":"C33+D33+E33","v":0},null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,0,"",""]
["     Restricted ",9740,{"$f":"L49+U49","v":0},null,null,{"$f":"C34+D34+E34","v":0},null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,0,"",""]
["     Committed ","9750-9760",{"$f":"L51+L52+U51+U52","v":0},null,null,{"$f":"C35+D35+E35","v":0},null,"F. FUND BALANCE, RESERVES","","","","","",null,"F. FUND BALANCE, RESERVES","","","","","","","",""]
["     Assigned ",9780,{"$f":"L54+U54","v":0},null,null,{"$f":"C36+D36+E36","v":0},null,"1) Beginning Fund Balance","","","","","",null,"1) Beginning Fund Balance","","","","","","","",""]
["     Reserve for Economic Uncertainties",9789,{"$f":"U56","v":0},null,null,{"$f":"C37+D37+E37","v":0},null,"a) As of July 1 - Unaudited","","9791",0,0,0,null,"a) As of July 1 - Unaudited","","9791",0,0,"",0,0,0]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C31-SUM(C33:C37)","v":0},{"$f":"D31-SUM(D33:D37)","v":0},{"$f":"E31-SUM(E33:E37)","v":0},{"$f":"F31-SUM(F33:F37)","v":0},null,"b) Audit Adjustments","","9793",0,0,0,null,"b) Audit Adjustments","","9793",0,0,"",0,0,0]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive",null,null,null,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,0,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Other Restatements","","9795",0,0,0,null,"d) Other Restatements","","9795",0,0,"",0,0,0]
[null,null,null,null,null,null,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,0,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,0,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Components of Ending Fund Balance","","","","","",null,"Components of Ending Fund Balance","","","","","","","",""]
[null,null,null,null,null,null,null,"a) Nonspendable","","","","","",null,"a) Nonspendable","","","","","","","",""]
[null,null,null,null,null,null,null,"Revolving Cash","","9711",0,0,0,null,"Revolving Cash","","9711",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Stores","","9712",0,0,0,null,"Stores","","9712",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Prepaid Items","","9713",0,0,0,null,"Prepaid Items","","9713",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"All Others","","9719",0,0,0,null,"All Others","","9719",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"b) Restricted","","9740",0,0,0,null,"b) Restricted","","9740",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"c) Committed","","","",0,"",null,"c) Committed","","","","","",0,"",""]
[null,null,null,null,null,null,null,"Stabilization Arrangements","","9750",0,0,0,null,"Stabilization Arrangements","","9750",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Other Commitments","","9760",0,0,0,null,"Other Commitments","","9760",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Assigned","","","","","",null,"d) Assigned","","","","","","","",""]
[null,null,null,null,null,null,null,"Other Assignments","","9780",0,0,0,null,"Other Assignments","","9780",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"e) Unassigned/Unappropriated Reserve for Economic Uncertainties","","9789",0,0,0,null,"e) Unassigned/Unappropriated","","","","","","","",""]
[null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,0,null,"Reserve for Economic Uncertainties","","9789",0,0,"",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,"",0,"",""]

{"sheet":"Page 4g Other Enterprise Fund","index":16,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[22,0,22,1],[23,0,23,1],[26,0,26,1],[31,0,31,1],[38,2,38,5],[13,0,13,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,5,22],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[7,7,7,12],[7,14,7,22],[8,0,8,1],[12,0,12,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"To auto-populate the Latest Board Approved budget, export the fund to Excel from your latest SACS file.  Paste the Adopted budget in H9:M56, or paste the Interim Budget in O9:W57.  Do not paste in both, only paste the most recent board-approved budget and leave the other with zeros.  Only copy from SACS the lines shown in yellow - do not copy headers.  If SACS exports blanks for any line instead of zeros, manually enter a zero. Update formulas for Components of Ending Fund Balance as needed. Contact your DFA with questions."]
[]
[null,null,"Fund 63 - Other Enterprise Fund"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,"Description","Resource Codes","Object Codes","XXXX-XX\nEstimated Actuals","XXXX-XX\nBudget","Percent\nDifference",null,"Description","Resource Codes","Object Codes","Original Budget\n(A)","Board Approved Operating Budget\n(B)","Actuals To Date\n(C)","Projected Year Totals\n(D)","Difference (Col B & D)\n(E)","% Diff Column B & D\n(F)"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) ",null,"Paste Adopted Excel Export from SACS Fund here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,"OR","Paste Interim Excel Export from SACS Fund here (description line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
["REVENUES",null,null,null,null,null,null,"1) LCFF Sources","","8010-8099",0,0,0,null,"1) LCFF Sources","","8010-8099",0,0,0,0,0,0]
["     Federal Revenue","8100-8299",{"$f":"L10+U10","v":0},null,null,{"$f":"C10+E10","v":0},null,"2) Federal Revenue","","8100-8299",0,0,0,null,"2) Federal Revenue","","8100-8299",0,0,0,0,0,0]
["     Other State Revenue","8300-8599",{"$f":"L11+U11","v":0},null,null,{"$f":"C11+E11","v":0},null,"3) Other State Revenue","","8300-8599",0,0,0,null,"3) Other State Revenue","","8300-8599",0,0,0,0,0,0]
["     Other Local Revenue","8600-8799",{"$f":"L12+U12","v":0},null,null,{"$f":"C12+E12","v":0},null,"4) Other Local Revenue","","8600-8799",0,0,0,null,"4) Other Local Revenue","","8600-8799",0,0,0,0,0,0]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},null,"5) TOTAL, REVENUES","","",0,0,0,null,"5) TOTAL, REVENUES","","",0,0,0,0,"",""]
["EXPENDITURES",null,null,null,null,null,null,"B. EXPENDITURES","","","","","",null,"B. EXPENDITURES","","","","","","","",""]
["     Certificated Salaries ","1000-1999",{"$f":"L15+U15","v":0},null,null,{"$f":"C15+D15+E15","v":0},null,"1) Certificated Salaries","","1000-1999",0,0,0,null,"1) Certificated Salaries","","1000-1999",0,0,0,0,0,0]
["     Classified Salaries","2000-2999",0,null,null,{"$f":"C16+D16+E16","v":0},null,"2) Classified Salaries","","2000-2999",0,0,0,null,"2) Classified Salaries","","2000-2999",0,0,0,0,0,0]
["     Employee Benefits","3000-3999",0,null,null,{"$f":"C17+D17+E17","v":0},null,"3) Employee Benefits","","3000-3999",0,0,0,null,"3) Employee Benefits","","3000-3999",0,0,0,0,0,0]
["     Books and Supplies","4000-4999",0,null,null,{"$f":"C18+E18","v":0},null,"4) Books and Supplies","","4000-4999",0,0,0,null,"4) Books and Supplies","","4000-4999",0,0,0,0,0,0]
["     Services and Other Operating Expenditures","5000-5999",0,null,null,{"$f":"C19+E19","v":0},null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,0,0,0]
["     Capital Outlay","6000-6999",0,null,null,{"$f":"C20+E20","v":0},null,"6) Capital Outlay","","6000-6999",0,0,0,null,"6) Capital Outlay","","6000-6999",0,0,0,0,0,0]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",0,null,null,{"$f":"C21+E21","v":0},null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299, 7400-7499",0,0,0,null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299,7400-7499",0,0,0,0,0,0]
["     Transfers of Indirect Costs","7300-7399",0,null,null,{"$f":"C22+E22","v":0},null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,0,0,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},null,"9) TOTAL, EXPENDITURES","","",0,0,0,null,"9) TOTAL, EXPENDITURES","","",0,0,0,0,"",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,0,"",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"L27+U27+L30+U30","v":0},null,null,{"$f":"C25+D25+E25","v":0},null,"D. OTHER FINANCING SOURCES/USES","","","","","",null,"D. OTHER FINANCING SOURCES/USES","","","","","","","",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"L28+U28+L31+U31","v":0},null,null,{"$f":"C26+D26+E26","v":0},null,"1) Interfund Transfers","","","","","",null,"1) Interfund Transfers","","","","","","","",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C13-C23+C25-C26","v":0},{"$f":"D13-D23+D25-D26","v":0},{"$f":"E13-E23+E25-E26","v":0},{"$f":"F13-F23+F25-F26","v":0},null,"a) Transfers In","","8900-8929",0,0,0,null,"a) Transfers In","","8900-8929",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"b) Transfers Out","","7600-7629",0,0,0,null,"b) Transfers Out","","7600-7629",0,0,0,0,0,0]
["BEGINNING FUND BALANCE ",9791,{"$f":"L37+U37","v":0},null,null,{"$f":"C29","v":0},null,"2) Other Sources/Uses","","","","","",null,"2) Other Sources/Uses","","","","","","","",""]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"L38+L40+U38+U40","v":0},null,null,{"$f":"C30","v":0},null,"a) Sources","","8930-8979",0,0,0,null,"a) Sources","","8930-8979",0,0,0,0,0,0]
["ENDING FUND BALANCE ",null,{"$f":"C27+C29+C30","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},{"$f":"F27+F29+F30","v":0},null,"b) Uses","","7630-7699",0,0,0,null,"b) Uses","","7630-7699",0,0,0,0,0,0]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,"3) Contributions","","8980-8999",0,0,0,null,"3) Contributions","","8980-8999",0,0,0,0,0,0]
["     Nonspendable ","9711-9719",{"$f":"L45+L46+L47+L48+U45+U46+U47+U48","v":0},null,null,{"$f":"C33+D33+E33","v":0},null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,0,"",""]
["     Restricted ",9740,{"$f":"L49+U49","v":0},null,null,{"$f":"C34+D34+E34","v":0},null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,0,"",""]
["     Committed ","9750-9760",{"$f":"L51+L52+U51+U52","v":0},null,null,{"$f":"C35+D35+E35","v":0},null,"F. FUND BALANCE, RESERVES","","","","","",null,"F. FUND BALANCE, RESERVES","","","","","","","",""]
["     Assigned ",9780,{"$f":"L54+U54","v":0},null,null,{"$f":"C36+D36+E36","v":0},null,"1) Beginning Fund Balance","","","","","",null,"1) Beginning Fund Balance","","","","","","","",""]
["     Reserve for Economic Uncertainties",9789,{"$f":"U56","v":0},null,null,{"$f":"C37+D37+E37","v":0},null,"a) As of July 1 - Unaudited","","9791",0,0,0,null,"a) As of July 1 - Unaudited","","9791",0,0,"",0,0,0]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C31-SUM(C33:C37)","v":0},{"$f":"D31-SUM(D33:D37)","v":0},{"$f":"E31-SUM(E33:E37)","v":0},{"$f":"F31-SUM(F33:F37)","v":0},null,"b) Audit Adjustments","","9793",0,0,0,null,"b) Audit Adjustments","","9793",0,0,"",0,0,0]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive",null,null,null,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,0,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Other Restatements","","9795",0,0,0,null,"d) Other Restatements","","9795",0,0,"",0,0,0]
[null,null,null,null,null,null,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,0,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,0,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Components of Ending Fund Balance","","","","","",null,"Components of Ending Fund Balance","","","","","","","",""]
[null,null,null,null,null,null,null,"a) Nonspendable","","","","","",null,"a) Nonspendable","","","","","","","",""]
[null,null,null,null,null,null,null,"Revolving Cash","","9711",0,0,0,null,"Revolving Cash","","9711",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Stores","","9712",0,0,0,null,"Stores","","9712",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Prepaid Items","","9713",0,0,0,null,"Prepaid Items","","9713",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"All Others","","9719",0,0,0,null,"All Others","","9719",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"b) Restricted","","9740",0,0,0,null,"b) Restricted","","9740",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"c) Committed","","","",0,"",null,"c) Committed","","","","","",0,"",""]
[null,null,null,null,null,null,null,"Stabilization Arrangements","","9750",0,0,0,null,"Stabilization Arrangements","","9750",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Other Commitments","","9760",0,0,0,null,"Other Commitments","","9760",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Assigned","","","","","",null,"d) Assigned","","","","","","","",""]
[null,null,null,null,null,null,null,"Other Assignments","","9780",0,0,0,null,"Other Assignments","","9780",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"e) Unassigned/Unappropriated Reserve for Economic Uncertainties","","9789",0,0,0,null,"e) Unassigned/Unappropriated","","","","","","","",""]
[null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,0,null,"Reserve for Economic Uncertainties","","9789",0,0,"",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,"",0,"",""]

{"sheet":"Page 4h Other Fund","index":17,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[13,0,13,1],[0,0,0,5],[1,0,1,5],[2,0,2,5],[2,7,5,22],[3,0,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[7,7,7,12],[7,14,7,22],[8,0,8,1],[12,0,12,1],[22,0,22,1],[23,0,23,1],[26,0,26,1],[31,0,31,1],[38,2,38,5]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["G.  IMPACT OF PROPOSED AGREEMENT(S) ON CURRENT YEAR OPERATING BUDGET",null,null,null,null,null,null,"To auto-populate the Latest Board Approved budget, export the fund to Excel from your latest SACS file.  Paste the Adopted budget in H9:M56, or paste the Interim Budget in O9:W57.  Do not paste in both, only paste the most recent board-approved budget and leave the other with zeros.  Only copy from SACS the lines shown in yellow - do not copy headers.  If SACS exports blanks for any line instead of zeros, manually enter a zero. Update formulas for Components of Ending Fund Balance as needed. Contact your DFA with questions."]
[]
["Enter Fund:"]
[]
[null,null,"Column 1","Column 2","Column 3","Column 4",null,"Description","Resource Codes","Object Codes","XXXX-XX\nEstimated Actuals","XXXX-XX\nBudget","Percent\nDifference",null,"Description","Resource Codes","Object Codes","Original Budget\n(A)","Board Approved Operating Budget\n(B)","Actuals To Date\n(C)","Projected Year Totals\n(D)","Difference (Col B & D)\n(E)","% Diff Column B & D\n(F)"]
[null,"Object Code",{"$f":"+'Page 4a, Unrest GF'!C8","v":"Latest Board-Approved Budget Before Settlement  (As of xxxxxx) "},"Adjustments as a Result of Settlement (compensation)","Other Revisions (agreement support and/or other unit agreement)       Explain on Page 4i","Total Revised   Budget          (Columns 1+2+3) ",null,"Paste Adopted Excel Export from SACS Fund here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,"OR","Paste Interim Excel Export from SACS Fund here (description line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
["REVENUES",null,null,null,null,null,null,"1) LCFF Sources","","8010-8099",0,0,0,null,"1) LCFF Sources","","8010-8099",0,0,0,0,0,0]
["     Federal Revenue","8100-8299",{"$f":"L10+U10","v":0},null,null,{"$f":"C10+E10","v":0},null,"2) Federal Revenue","","8100-8299",0,0,0,null,"2) Federal Revenue","","8100-8299",0,0,0,0,0,0]
["     Other State Revenue","8300-8599",{"$f":"L11+U11","v":0},null,null,{"$f":"C11+E11","v":0},null,"3) Other State Revenue","","8300-8599",0,0,0,null,"3) Other State Revenue","","8300-8599",0,0,0,0,0,0]
["     Other Local Revenue","8600-8799",{"$f":"L12+U12","v":0},null,null,{"$f":"C12+E12","v":0},null,"4) Other Local Revenue","","8600-8799",0,0,0,null,"4) Other Local Revenue","","8600-8799",0,0,0,0,0,0]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C12)","v":0},null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},null,"5) TOTAL, REVENUES","","",0,0,0,null,"5) TOTAL, REVENUES","","",0,0,0,0,"",""]
["EXPENDITURES",null,null,null,null,null,null,"B. EXPENDITURES","","","","","",null,"B. EXPENDITURES","","","","","","","",""]
["     Certificated Salaries ","1000-1999",{"$f":"L15+U15","v":0},null,null,{"$f":"C15+D15+E15","v":0},null,"1) Certificated Salaries","","1000-1999",0,0,0,null,"1) Certificated Salaries","","1000-1999",0,0,0,0,0,0]
["     Classified Salaries","2000-2999",0,null,null,{"$f":"C16+D16+E16","v":0},null,"2) Classified Salaries","","2000-2999",0,0,0,null,"2) Classified Salaries","","2000-2999",0,0,0,0,0,0]
["     Employee Benefits","3000-3999",0,null,null,{"$f":"C17+D17+E17","v":0},null,"3) Employee Benefits","","3000-3999",0,0,0,null,"3) Employee Benefits","","3000-3999",0,0,0,0,0,0]
["     Books and Supplies","4000-4999",0,null,null,{"$f":"C18+E18","v":0},null,"4) Books and Supplies","","4000-4999",0,0,0,null,"4) Books and Supplies","","4000-4999",0,0,0,0,0,0]
["     Services and Other Operating Expenditures","5000-5999",0,null,null,{"$f":"C19+E19","v":0},null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,null,"5) Services and Other Operating Expenditures","","5000-5999",0,0,0,0,0,0]
["     Capital Outlay","6000-6999",0,null,null,{"$f":"C20+E20","v":0},null,"6) Capital Outlay","","6000-6999",0,0,0,null,"6) Capital Outlay","","6000-6999",0,0,0,0,0,0]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",0,null,null,{"$f":"C21+E21","v":0},null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299, 7400-7499",0,0,0,null,"7) Other Outgo (excluding Transfers of Indirect Costs)","","7100-7299,7400-7499",0,0,0,0,0,0]
["     Transfers of Indirect Costs","7300-7399",0,null,null,{"$f":"C22+E22","v":0},null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,null,"8) Other Outgo - Transfers of Indirect Costs","","7300-7399",0,0,0,0,0,0]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},null,"9) TOTAL, EXPENDITURES","","",0,0,0,null,"9) TOTAL, EXPENDITURES","","",0,0,0,0,"",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,null,"C. EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES BEFORE OTHER FINANCING SOURCES AND USES (A5 - B9)","","",0,0,0,0,"",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"L27+U27+L30+U30","v":0},null,null,{"$f":"C25+D25+E25","v":0},null,"D. OTHER FINANCING SOURCES/USES","","","","","",null,"D. OTHER FINANCING SOURCES/USES","","","","","","","",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"L28+U28+L31+U31","v":0},null,null,{"$f":"C26+D26+E26","v":0},null,"1) Interfund Transfers","","","","","",null,"1) Interfund Transfers","","","","","","","",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C13-C23+C25-C26","v":0},{"$f":"D13-D23+D25-D26","v":0},{"$f":"E13-E23+E25-E26","v":0},{"$f":"F13-F23+F25-F26","v":0},null,"a) Transfers In","","8900-8929",0,0,0,null,"a) Transfers In","","8900-8929",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"b) Transfers Out","","7600-7629",0,0,0,null,"b) Transfers Out","","7600-7629",0,0,0,0,0,0]
["BEGINNING FUND BALANCE ",9791,{"$f":"L37+U37","v":0},null,null,{"$f":"C29","v":0},null,"2) Other Sources/Uses","","","","","",null,"2) Other Sources/Uses","","","","","","","",""]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"L38+L40+U38+U40","v":0},null,null,{"$f":"C30","v":0},null,"a) Sources","","8930-8979",0,0,0,null,"a) Sources","","8930-8979",0,0,0,0,0,0]
["ENDING FUND BALANCE ",null,{"$f":"C27+C29+C30","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0},{"$f":"F27+F29+F30","v":0},null,"b) Uses","","7630-7699",0,0,0,null,"b) Uses","","7630-7699",0,0,0,0,0,0]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,"3) Contributions","","8980-8999",0,0,0,null,"3) Contributions","","8980-8999",0,0,0,0,0,0]
["     Nonspendable ","9711-9719",{"$f":"L45+L46+L47+L48+U45+U46+U47+U48","v":0},null,null,{"$f":"C33+D33+E33","v":0},null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,null,"4) TOTAL, OTHER FINANCING SOURCES/USES","","",0,0,0,0,"",""]
["     Restricted ",9740,{"$f":"L49+U49","v":0},null,null,{"$f":"C34+D34+E34","v":0},null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,null,"E. NET INCREASE (DECREASE) IN FUND BALANCE (C + D4)","","",0,0,0,0,"",""]
["     Committed ","9750-9760",{"$f":"L51+L52+U51+U52","v":0},null,null,{"$f":"C35+D35+E35","v":0},null,"F. FUND BALANCE, RESERVES","","","","","",null,"F. FUND BALANCE, RESERVES","","","","","","","",""]
["     Assigned ",9780,{"$f":"L54+U54","v":0},null,null,{"$f":"C36+D36+E36","v":0},null,"1) Beginning Fund Balance","","","","","",null,"1) Beginning Fund Balance","","","","","","","",""]
["     Reserve for Economic Uncertainties",9789,{"$f":"U56","v":0},null,null,{"$f":"C37+D37+E37","v":0},null,"a) As of July 1 - Unaudited","","9791",0,0,0,null,"a) As of July 1 - Unaudited","","9791",0,0,"",0,0,0]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C31-SUM(C33:C37)","v":0},{"$f":"D31-SUM(D33:D37)","v":0},{"$f":"E31-SUM(E33:E37)","v":0},{"$f":"F31-SUM(F33:F37)","v":0},null,"b) Audit Adjustments","","9793",0,0,0,null,"b) Audit Adjustments","","9793",0,0,"",0,0,0]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts in Columns 1 and 4 must be positive",null,null,null,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,0,null,"c) As of July 1 - Audited (F1a + F1b)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Other Restatements","","9795",0,0,0,null,"d) Other Restatements","","9795",0,0,"",0,0,0]
[null,null,null,null,null,null,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,0,null,"e) Adjusted Beginning Balance (F1c + F1d)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,0,null,"2) Ending Balance, June 30 (E + F1e)","","",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Components of Ending Fund Balance","","","","","",null,"Components of Ending Fund Balance","","","","","","","",""]
[null,null,null,null,null,null,null,"a) Nonspendable","","","","","",null,"a) Nonspendable","","","","","","","",""]
[null,null,null,null,null,null,null,"Revolving Cash","","9711",0,0,0,null,"Revolving Cash","","9711",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Stores","","9712",0,0,0,null,"Stores","","9712",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Prepaid Items","","9713",0,0,0,null,"Prepaid Items","","9713",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"All Others","","9719",0,0,0,null,"All Others","","9719",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"b) Restricted","","9740",0,0,0,null,"b) Restricted","","9740",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"c) Committed","","","",0,"",null,"c) Committed","","","","","",0,"",""]
[null,null,null,null,null,null,null,"Stabilization Arrangements","","9750",0,0,0,null,"Stabilization Arrangements","","9750",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"Other Commitments","","9760",0,0,0,null,"Other Commitments","","9760",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"d) Assigned","","","","","",null,"d) Assigned","","","","","","","",""]
[null,null,null,null,null,null,null,"Other Assignments","","9780",0,0,0,null,"Other Assignments","","9780",0,0,"",0,"",""]
[null,null,null,null,null,null,null,"e) Unassigned/Unappropriated Reserve for Economic Uncertainties","","9789",0,0,0,null,"e) Unassigned/Unappropriated","","","","","","","",""]
[null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,0,null,"Reserve for Economic Uncertainties","","9789",0,0,"",0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unassigned/Unappropriated Amount","","9790",0,0,"",0,"",""]

{"sheet":"Page 4i, Column 3 Explanations","index":18,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,40,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,1,33,5],[34,1,34,2],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,1,38,5],[39,1,39,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,1,28,5],[29,1,29,2],[29,4,29,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,1,23,5],[24,1,24,2],[24,4,24,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,1,18,5],[19,1,19,2],[19,4,19,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,1,13,5],[14,1,14,2],[14,4,14,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,1,8,5],[9,1,9,2],[9,4,9,5],[0,0,0,5],[1,0,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,2],[4,4,4,5]]}
[]
[]
[null,"Explanations for Column 3 \"Other Revisions\" entered on Pages 4a through 4h:",null,null,null,null,null,null,"Section G, Pages 4a through 4i:  Impact of Proposed Agreement on Current-Year Operating Budget"]
[null,null,null,null,null,null,null,null,"for General, Adult Education, Child Development, Cafeteria and Other Funds"]
[null,"Page 4a: Unrestricted General Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"+'Page 4a, Unrest GF'!E14","v":0},null,null,null,{"$f":"IF(D6=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"+'Page 4a, Unrest GF'!E24","v":0},null,null,null,{"$f":"IF(D7=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Other Financing Sources/Uses",{"$f":"+'Page 4a, Unrest GF'!E26-'Page 4a, Unrest GF'!E27+'Page 4a, Unrest GF'!E28","v":0},null,null,null,""]
[]
[null,"Page 4b: Restricted General Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"+'Page 4b. Rest GF'!E14","v":0},null,null,null,{"$f":"IF(D11=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"+'Page 4b. Rest GF'!E24","v":0},null,null,null,""]
[null,null,"Other Financing Sources/Uses",{"$f":"+'Page 4b. Rest GF'!E26-'Page 4b. Rest GF'!E27+'Page 4b. Rest GF'!E28","v":0},null,null,null,""]
[]
[null,"Page 4d: Fund 11 - Adult Education Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"+'Page 4d Adult Education Fund'!E13","v":0},null,null,null,{"$f":"IF(D16=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"+'Page 4d Adult Education Fund'!E23","v":0},null,null,null,""]
[null,null,"Other Financing Sources/Uses",{"$f":"+'Page 4d Adult Education Fund'!E25-'Page 4d Adult Education Fund'!E26","v":0},null,null,null,""]
[]
[null,"Page 4e: Fund 12 - Child Development Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"'Page 4e Child Development Fund'!E13","v":0},null,null,null,{"$f":"IF(D21=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"'Page 4e Child Development Fund'!E23","v":0},null,null,null,""]
[null,null,"Other Financing Sources/Uses",{"$f":"'Page 4e Child Development Fund'!E25+'Page 4e Child Development Fund'!E26","v":0},null,null,null,""]
[]
[null,"Page 4f: Fund 13/61 - Cafeteria Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"'Page 4f Cafeteria Fund'!E13","v":0},null,null,null,{"$f":"IF(D26=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"'Page 4f Cafeteria Fund'!E23","v":0},null,null,null,{"$f":"IF(D27=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Other Financing Sources/Uses",{"$f":"'Page 4f Cafeteria Fund'!E25+'Page 4f Cafeteria Fund'!E26","v":0},null,null,null,""]
[]
[null,"Page 4g:  Fund 63 - Other Enterprise Fund",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"'Page 4g Other Enterprise Fund'!E13","v":0},null,null,null,{"$f":"IF(D31=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"'Page 4g Other Enterprise Fund'!E23","v":0},null,null,null,""]
[null,null,"Other Financing Sources/Uses",{"$f":"'Page 4g Other Enterprise Fund'!E25+'Page 4g Other Enterprise Fund'!E26","v":0},null,null,null,""]
[]
[null,"Page 4h:  Other",null,"Amount","Explanation"]
[null,null,"Revenues",{"$f":"'Page 4h Other Fund'!E13","v":0},null,null,null,{"$f":"IF(D36=0,\"\",\"EXPLANATION IS REQUIRED\")","v":""}]
[null,null,"Expenditures",{"$f":"'Page 4h Other Fund'!E23","v":0},null,null,null,""]
[null,null,"Other Financing Sources/Uses",{"$f":"'Page 4h Other Fund'!E25+'Page 4h Other Fund'!E26","v":0},null,null,null,""]
[]
[null,"Additional Comments:"]
[null,null,null,null,null,null,null,"`"]

{"sheet":"Page 5a MYP Unrest GF","index":19,"n_rows":70,"n_cols":23,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,4],[34,0,34,1],[2,0,2,4],[3,0,3,4],[4,0,4,1],[4,2,4,4],[4,8,6,14],[63,16,63,17],[4,16,6,22],[41,0,41,1],[41,2,41,4],[42,2,42,4],[5,0,5,1],[5,2,5,4],[6,0,7,0],[8,0,8,1],[13,0,13,1],[14,0,14,1],[24,0,24,1],[25,0,25,1],[29,0,29,1],[33,0,33,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["H.  IMPACT OF PROPOSED AGREEMENT ON SUBSEQUENT YEARS",null,null,null,null,null,"Section H, Pages 5a through 5c:  Impact of Proposed Agreement on Subsequent Years"]
[]
[null,null,"Unrestricted General Fund MYP",null,null,null,null,null,"If Adopted is the most recent board-approved budget, paste Adopted Excel Export from SACS Fund 01 Unrestricted Tab here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,null,null,"If an Interim Budget is the most recent board-approved budget, paste Interim Excel Export from SACS Fund 01 Unrestricted Tab here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
[]
[null,null,{"$f":"+'Page 1a, Cost of the agreement'!E27","v":0},{"$f":"+'Page 1a, Cost of the agreement'!F27","v":{"$error":"#VALUE!"}},{"$f":"+'Page 1a, Cost of the agreement'!G27","v":{"$error":"#VALUE!"}}]
[null,"Object Code","Total Revised Budget After Settlement ","First Subsequent Year After Settlement","Second Subsequent Year After Settlement",null,null,null,"Description","Object\nCodes","Year 1\nBudget\n(Form 01)\n(A)","%\nChange\n(Cols. C-A/A)\n(B)","Year 2\nProjection\n(C)","%\nChange\n(Cols. E-C/C)\n(D)","Year 3\nProjection (E)","OR","Description","Object\nCodes","Year 1\nBudget\n(Form 01)\n(A)","%\nChange\n(Cols. C-A/A)\n(B)","Year 2\nProjection\n(C)","%\nChange\n(Cols. E-C/C)\n(D)","Year 3\nProjection (E)"]
["REVENUES",null,null,null,null,null,null,null,"1. LCFF/Revenue Limit Sources","8010-8099",null,null,null,null,null,null,"1. LCFF/Revenue Limit Sources","8010-8099"]
["     LCFF Revenue","8010-8099",{"$f":"+'Page 4a, Unrest GF'!F10","v":0},{"$f":"M9+U9","v":0},{"$f":"O9+W9","v":0},null,null,null,"2. Federal Revenues","8100-8299",null,null,null,null,null,null,"2. Federal Revenues","8100-8299"]
["     Federal Revenue","8100-8299",{"$f":"+'Page 4a, Unrest GF'!F11","v":0},{"$f":"M10+U10","v":0},{"$f":"O10+W10","v":0},null,null,null,"3. Other State Revenues","8300-8599",null,null,null,null,null,null,"3. Other State Revenues","8300-8599"]
["     Other State Revenue","8300-8599",{"$f":"+'Page 4a, Unrest GF'!F12","v":0},{"$f":"M11+U11","v":0},{"$f":"O11+W11","v":0},null,null,null,"4. Other Local Revenues","8600-8799",null,null,null,null,null,null,"4. Other Local Revenues","8600-8799"]
["     Other Local Revenue","8600-8799",{"$f":"+'Page 4a, Unrest GF'!F13","v":0},{"$f":"M12+U12","v":0},{"$f":"O12+W12","v":0},null,null,null,"5. Other Financing Sources","",null,null,null,null,null,null,"5. Other Financing Sources",""]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0},null,null,null,"a. Transfers In","8900-8929",null,null,null,null,null,null,"a. Transfers In","8900-8929"]
["EXPENDITURES",null,null,null,null,null,null,null,"b. Other Sources","8930-8979",null,null,null,null,null,null,"b. Other Sources","8930-8979"]
["     Certificated Salaries ","1000-1999",{"$f":"+'Page 4a, Unrest GF'!F16","v":0},{"$f":"M24+U24","v":0},{"$f":"O24+W24","v":0},null,null,null,"c. Contributions","8980-8999",null,null,null,null,null,null,"c. Contributions","8980-8999"]
["     Classified Salaries","2000-2999",{"$f":"+'Page 4a, Unrest GF'!F17","v":0},{"$f":"M30+U30","v":0},{"$f":"O30+W30","v":0},null,null,null,"6. Total (Sum lines A1 thru A5c)","",null,null,null,null,null,null,"6. Total (Sum lines A1 thru A5c)",""]
["     Employee Benefits","3000-3999",{"$f":"+'Page 4a, Unrest GF'!F18","v":0},0,0,null,null,null,"B. EXPENDITURES AND OTHER FINANCING USES","",null,null,null,null,null,null,"B. EXPENDITURES AND OTHER FINANCING USES",""]
["     Books and Supplies","4000-4999",{"$f":"+'Page 4a, Unrest GF'!F19","v":0},0,0,null,null,null,"1. Certificated Salaries","",null,null,null,null,null,null,"1. Certificated Salaries",""]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"+'Page 4a, Unrest GF'!F20","v":0},0,0,null,null,null,"a. Base Salaries","",null,null,null,null,null,null,"a. Base Salaries",""]
["     Capital Outlay","6000-6999",{"$f":"+'Page 4a, Unrest GF'!F21","v":0},0,0,null,null,null,"b. Step & Column Adjustment","",null,null,null,null,null,null,"b. Step & Column Adjustment",""]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",{"$f":"+'Page 4a, Unrest GF'!F22","v":0},0,0,null,null,null,"c. Cost-of-Living Adjustment","",null,null,null,null,null,null,"c. Cost-of-Living Adjustment",""]
["    Transfers of Indirect Costs","7300-7399",{"$f":"+'Page 4a, Unrest GF'!F23","v":0},0,0,null,null,null,"d. Other Adjustments","",null,null,null,null,null,null,"d. Other Adjustments",""]
["     Other Adjustments",null,null,{"$f":"M29+U29","v":0},{"$f":"O40+W40","v":0},null,null,null,"e. Total Certificated Salaries (Sum lines B1a thru B1d)","1000-1999",null,null,null,null,null,null,"e. Total Certificated Salaries (Sum lines B1a thru B1d)","1000-1999"]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},null,null,null,"2. Classified Salaries","",null,null,null,null,null,null,"2. Classified Salaries",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,null,"a. Base Salaries","",null,null,null,null,null,null,"a. Base Salaries",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"+'Page 4a, Unrest GF'!F26","v":0},{"$f":"M14+M15+U14+U15","v":0},{"$f":"O14+O15+W14+W15","v":0},null,null,null,"b. Step & Column Adjustment","",null,null,null,null,null,null,"b. Step & Column Adjustment",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"+'Page 4a, Unrest GF'!F27","v":0},{"$f":"M38+M39+U38+U39","v":0},{"$f":"O38+O39+W38+W39","v":0},null,null,null,"c. Cost-of-Living Adjustment","",null,null,null,null,null,null,"c. Cost-of-Living Adjustment",""]
["     Contributions","8980-8999",{"$f":"+'Page 4a, Unrest GF'!F28","v":0},{"$f":"M16+U16","v":0},{"$f":"O16+W16","v":0},null,null,null,"d. Other Adjustments","",null,null,null,null,null,null,"d. Other Adjustments",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C25+C27-C28+C29","v":0},{"$f":"D14-D25+D27-D28+D29","v":0},{"$f":"E14-E25+E27-E28+E29","v":0},null,null,null,"e. Total Classified Salaries (Sum lines B2a thru B2d)","2000-2999",null,null,null,null,null,null,"e. Total Classified Salaries (Sum lines B2a thru B2d)","2000-2999"]
[null,null,null,null,null,null,null,null,"3. Employee Benefits","3000-3999",null,null,null,null,null,null,"3. Employee Benefits","3000-3999"]
["BEGINNING FUND BALANCE ",9791,{"$f":"+'Page 4a, Unrest GF'!C31","v":0},{"$f":"C34","v":0},{"$f":"D34","v":0},null,null,null,"4. Books and Supplies","4000-4999",null,null,null,null,null,null,"4. Books and Supplies","4000-4999"]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"+'Page 4a, Unrest GF'!C32","v":0},null,null,null,null,null,"5. Services and Other Operating Expenditures","5000-5999",null,null,null,null,null,null,"5. Services and Other Operating Expenditures","5000-5999"]
["ENDING FUND BALANCE ",null,{"$f":"C30+C32+C33","v":0},{"$f":"D30+D32","v":0},{"$f":"E30+E32","v":0},null,null,null,"6. Capital Outlay","6000-6999",null,null,null,null,null,null,"6. Capital Outlay","6000-6999"]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,null,"7. Other Outgo (excluding Transfers of Indirect Costs)","7100-7299, 7400-7499",null,null,null,null,null,null,"7. Other Outgo (excluding Transfers of Indirect Costs)","7100-7299, 7400-7499"]
["     Nonspendable ","9711-9719",{"$f":"+'Page 4a, Unrest GF'!F35","v":0},{"$f":"M47+U47","v":0},{"$f":"O47+W48","v":0},null,null,null,"8. Other Outgo - Transfers of Indirect Costs","7300-7399",null,null,null,null,null,null,"8. Other Outgo - Transfers of Indirect Costs","7300-7399"]
["     Restricted ",9740,null,null,null,null,null,null,"9. Other Financing Uses","",null,null,null,null,null,null,"9. Other Financing Uses",""]
["     Committed ","9750-9760",{"$f":"+'Page 4a, Unrest GF'!F37","v":0},{"$f":"M50+M51+U50+U51","v":0},{"$f":"O50+O51+W51+W52","v":0},null,null,null,"a. Transfers Out","7600-7629",null,null,null,null,null,null,"a. Transfers Out","7600-7629"]
["     Assigned ",9780,{"$f":"+'Page 4a, Unrest GF'!F38","v":0},{"$f":"M52+U52","v":0},{"$f":"O52+W53","v":0},null,null,null,"b. Other Uses","7630-7699",null,null,null,null,null,null,"b. Other Uses","7630-7699"]
["     Reserve for Economic Uncertainties",9789,{"$f":"+'Page 4a, Unrest GF'!F39","v":0},{"$f":"M54+U54","v":0},{"$f":"O54+W55","v":0},null,null,null,"10. Other Adjustments (Explain in Section F below)","",null,null,null,null,null,null,"10. Other Adjustments (Explain in Section F below)",""]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C34-SUM(C36:C40)","v":0},{"$f":"D34-SUM(D36:D40)","v":0},{"$f":"E34-SUM(E36:E40)","v":0},null,null,null,"11. Total (Sum lines B1 thru B10)","",null,null,null,null,null,null,"11. Total (Sum lines B1 thru B10)",""]
["*Enter Explanation for Other Adjustments:",null,null,null,null,null,null,null,"C. NET INCREASE (DECREASE) IN FUND BALANCE (Line A6 minus line B11)","",null,null,null,null,null,null,"C. NET INCREASE (DECREASE) IN FUND BALANCE",""]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts must be positive ",null,null,null,null,null,"D. FUND BALANCE","",null,null,null,null,null,null,"(Line A6 minus line B11)",""]
[null,null,null,null,null,null,null,null,"1. Net Beginning Fund Balance (Form 01, line F1e)","",null,null,null,null,null,null,"D. FUND BALANCE",""]
[null,null,null,null,null,null,null,null,"2. Ending Fund Balance (Sum lines C and D1)","",null,null,null,null,null,null,"1.Net Beginning Fund Balance(Form 01I, line F1e)",""]
[null,null,null,null,null,null,null,null,"3. Components of Ending Fund Balance","",null,null,null,null,null,null,"2. Ending Fund Balance (Sum lines C and D1)",""]
[null,null,null,null,null,null,null,null,"a. Nonspendable","9710-9719",null,null,null,null,null,null,"3. Components of Ending Fund Balance (Form 01I)",""]
[null,null,null,null,null,null,null,null,"b. Restricted","9740",null,null,null,null,null,null,"a. Nonspendable","9710-9719"]
[null,null,null,null,null,null,null,null,"c. Committed","",null,null,null,null,null,null,"b. Restricted","9740"]
[null,null,null,null,null,null,null,null,"1. Stabilization Arrangements","9750",null,null,null,null,null,null,"c. Committed",""]
[null,null,null,null,null,null,null,null,"2. Other Commitments","9760",null,null,null,null,null,null,"1. Stabilization Arrangements","9750"]
[null,null,null,null,null,null,null,null,"d. Assigned","9780",null,null,null,null,null,null,"2. Other Commitments","9760"]
[null,null,null,null,null,null,null,null,"e. Unassigned/Unappropriated","",null,null,null,null,null,null,"d. Assigned","9780"]
[null,null,null,null,null,null,null,null,"1. Reserve for Economic Uncertainties","9789",null,null,null,null,null,null,"e. Unassigned/Unappropriated",""]
[null,null,null,null,null,null,null,null,"2. Unassigned/Unappropriated","9790",null,null,null,null,null,null,"1. Reserve for Economic Uncertainties","9789"]
[null,null,null,null,null,null,null,null,"f. Total Components of Ending Fund Balance (Line D3f must agree with line D2)","",null,null,null,null,null,null,"2. Unassigned/Unappropriated","9790"]
[null,null,null,null,null,null,null,null,"E. AVAILABLE RESERVES","",null,null,null,null,null,null,"f. Total Components of Ending Fund Balance",""]
[null,null,null,null,null,null,null,null,"1. General Fund","",null,null,null,null,null,null,"(Line D3f must agree with line D2)",""]
[null,null,null,null,null,null,null,null,"a. Stabilization Arrangements","9750",null,null,null,null,null,null,"E. AVAILABLE RESERVES",""]
[null,null,null,null,null,null,null,null,"b. Reserve for Economic Uncertainties","9789",null,null,null,null,null,null,"1. General Fund",""]
[null,null,null,null,null,null,null,null,"c. Unassigned/Unappropriated","9790",null,null,null,null,null,null,"a. Stabilization Arrangements","9750"]
[null,null,null,null,null,null,null,null,"(Enter reserve projections for subsequent years 1 and 2 in Columns C and E; current year - Column A - is extracted.)","",null,null,null,null,null,null,"b. Reserve for Economic Uncertainties","9789"]
[null,null,null,null,null,null,null,null,"2. Special Reserve Fund - Noncapital Outlay (Fund 17)","",null,null,null,null,null,null,"c. Unassigned/Unappropriated","9790"]
[null,null,null,null,null,null,null,null,"a. Stabilization Arrangements","9750",null,null,null,null,null,null,"(Enter other reserve projections in Columns C and E for subsequent"]
[null,null,null,null,null,null,null,null,"b. Reserve for Economic Uncertainties","9789",null,null,null,null,null,null,"years 1 and 2; current year - Column A - is extracted)",""]
[null,null,null,null,null,null,null,null,"c. Unassigned/Unappropriated","9790",null,null,null,null,null,null,"2. Special Reserve Fund - Noncapital Outlay (Fund 17)",""]
[null,null,null,null,null,null,null,null,"3. Total Available Reserves (Sum lines E1a thru E2c)","",null,null,null,null,null,null,"a. Stabilization Arrangements","9750"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b. Reserve for Economic Uncertainties","9789"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c. Unassigned/Unappropriated","9790"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Total Available Reserves (Sum lines E1a thru E2c)",""]

{"sheet":"Page 5b MYP Rest GF","index":20,"n_rows":58,"n_cols":23,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,0,2,4],[3,0,3,4],[4,0,4,1],[4,2,4,4],[0,0,0,5],[1,0,1,4],[4,8,6,14],[4,16,6,22],[41,2,41,4],[5,0,5,1],[5,2,5,4],[6,0,7,0],[8,0,8,1],[13,0,13,1],[24,0,24,1],[25,0,25,1],[29,0,29,1],[33,0,33,1],[34,0,34,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["H.  IMPACT OF PROPOSED AGREEMENT ON SUBSEQUENT YEARS",null,null,null,null,null,"Section H, Pages 5a through 5c:  Impact of Proposed Agreement on Subsequent Years"]
[]
[null,null,"Restricted General Fund MYP",null,null,null,null,null,"If Adopted is the most recent board-approved budget, paste Adopted Excel Export from SACS Fund 01 Restricted Tab here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers.",null,null,null,null,null,null,null,"If Interim is the most recent board-approved budget, paste Interim Excel Export from SACS Fund 01 Restricted Tab here (LCFF Sources line through Unassigned/Unappropriated).  Convert cells w/ green triangle at top left to numbers."]
[]
[null,null,{"$f":"+'Page 5a MYP Unrest GF'!C7","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D7","v":{"$error":"#VALUE!"}},{"$f":"+'Page 5a MYP Unrest GF'!E7","v":{"$error":"#VALUE!"}}]
[null,"Object Code","Total Revised Budget After Settlement ","First Subsequent Year After Settlement","Second Subsequent Year After Settlement",null,null,null,"Description","Object\nCodes","Year 1\nBudget\n(Form 01)\n(A)","%\nChange\n(Cols. C-A/A)\n(B)","Year 2\nProjection\n(C)","%\nChange\n(Cols. E-C/C)\n(D)","Year 3\nProjection (E)",null,"Description","Object\nCodes","Year 1\nBudget\n(Form 01)\n(A)","%\nChange\n(Cols. C-A/A)\n(B)","Year 2\nProjection\n(C)","%\nChange\n(Cols. E-C/C)\n(D)","Year 3\nProjection (E)"]
["REVENUES",null,null,null,null,null,null,null,"1. LCFF/Revenue Limit Sources","8010-8099",null,null,null,null,null,null,"1. LCFF/Revenue Limit Sources","8010-8099"]
["     LCFF Revenue","8010-8099",{"$f":"+'Page 4b. Rest GF'!F10","v":0},{"$f":"M9+U9","v":0},{"$f":"O9+W9","v":0},null,null,null,"2. Federal Revenues","8100-8299",null,null,null,null,null,null,"2. Federal Revenues","8100-8299"]
["     Federal Revenue","8100-8299",{"$f":"+'Page 4b. Rest GF'!F11","v":0},{"$f":"M10+U10","v":0},{"$f":"O10+W10","v":0},null,null,null,"3. Other State Revenues","8300-8599",null,null,null,null,null,null,"3. Other State Revenues","8300-8599"]
["     Other State Revenue","8300-8599",{"$f":"+'Page 4b. Rest GF'!F12","v":0},{"$f":"M11+U11","v":0},{"$f":"O11+W11","v":0},null,null,null,"4. Other Local Revenues","8600-8799",null,null,null,null,null,null,"4. Other Local Revenues","8600-8799"]
["     Other Local Revenue","8600-8799",{"$f":"+'Page 4b. Rest GF'!F13","v":0},{"$f":"M12+U12","v":0},{"$f":"O12+W12","v":0},null,null,null,"5. Other Financing Sources","",null,null,null,null,null,null,"5. Other Financing Sources",""]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0},null,null,null,"a. Transfers In","8900-8929",null,null,null,null,null,null,"a. Transfers In","8900-8929"]
["EXPENDITURES",null,null,null,null,null,null,null,"b. Other Sources","8930-8979",null,null,null,null,null,null,"b. Other Sources","8930-8979"]
["     Certificated Salaries ","1000-1999",{"$f":"+'Page 4b. Rest GF'!F16","v":0},{"$f":"M24+U24","v":0},{"$f":"O24+W24","v":0},null,null,null,"c. Contributions","8980-8999",null,null,null,null,null,null,"c. Contributions","8980-8999"]
["     Classified Salaries","2000-2999",{"$f":"+'Page 4b. Rest GF'!F17","v":0},{"$f":"M30+U30","v":0},{"$f":"O30+W30","v":0},null,null,null,"6. Total (Sum lines A1 thru A5c)","",null,null,null,null,null,null,"6. Total (Sum lines A1 thru A5c)",""]
["     Employee Benefits","3000-3999",{"$f":"+'Page 4b. Rest GF'!F18","v":0},0,0,null,null,null,"B. EXPENDITURES AND OTHER FINANCING USES","",null,null,null,null,null,null,"B. EXPENDITURES AND OTHER FINANCING USES",""]
["     Books and Supplies","4000-4999",{"$f":"+'Page 4b. Rest GF'!F19","v":0},0,0,null,null,null,"1. Certificated Salaries","",null,null,null,null,null,null,"1. Certificated Salaries",""]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"+'Page 4b. Rest GF'!F20","v":0},0,0,null,null,null,"a. Base Salaries","",null,null,null,null,null,null,"a. Base Salaries",""]
["     Capital Outlay","6000-6999",{"$f":"+'Page 4b. Rest GF'!F21","v":0},0,0,null,null,null,"b. Step & Column Adjustment","",null,null,null,null,null,null,"b. Step & Column Adjustment",""]
["     Other Outgo (excluding Indirect Costs)","7100-7299  7400-7499",{"$f":"+'Page 4b. Rest GF'!F22","v":0},0,0,null,null,null,"c. Cost-of-Living Adjustment","",null,null,null,null,null,null,"c. Cost-of-Living Adjustment",""]
["    Transfers of Indirect Costs","7300-7399",{"$f":"+'Page 4b. Rest GF'!F23","v":0},0,0,null,null,null,"d. Other Adjustments","",null,null,null,null,null,null,"d. Other Adjustments",""]
["     Other Adjustments",null,null,{"$f":"M40+U40","v":0},{"$f":"O40+W40","v":0},null,null,null,"e. Total Certificated Salaries (Sum lines B1a thru B1d)","1000-1999",null,null,null,null,null,null,"e. Total Certificated Salaries (Sum lines B1a thru B1d)","1000-1999"]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},null,null,null,"2. Classified Salaries","",null,null,null,null,null,null,"2. Classified Salaries",""]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,null,"a. Base Salaries","",null,null,null,null,null,null,"a. Base Salaries",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"+'Page 4b. Rest GF'!F26","v":0},{"$f":"M14+M15+U14+U15","v":0},{"$f":"O14+O15+W14+W15","v":0},null,null,null,"b. Step & Column Adjustment","",null,null,null,null,null,null,"b. Step & Column Adjustment",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"+'Page 4b. Rest GF'!F27","v":0},{"$f":"M38+M39+U38+U39","v":0},{"$f":"O38+O39+W38+W39","v":0},null,null,null,"c. Cost-of-Living Adjustment","",null,null,null,null,null,null,"c. Cost-of-Living Adjustment",""]
["     Contributions","8980-8999",{"$f":"+'Page 4b. Rest GF'!F28","v":0},{"$f":"M16+U16","v":0},{"$f":"O16+W16","v":0},null,null,null,"d. Other Adjustments","",null,null,null,null,null,null,"d. Other Adjustments",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C25+C27-C28+C29","v":0},{"$f":"D14-D25+D27-D28+D29","v":0},{"$f":"E14-E25+E27-E28+E29","v":0},null,null,null,"e. Total Classified Salaries (Sum lines B2a thru B2d)","2000-2999",null,null,null,null,null,null,"e. Total Classified Salaries (Sum lines B2a thru B2d)","2000-2999"]
[null,null,null,null,null,null,null,null,"3. Employee Benefits","3000-3999",null,null,null,null,null,null,"3. Employee Benefits","3000-3999"]
["BEGINNING FUND BALANCE ",9791,{"$f":"+'Page 4b. Rest GF'!F31","v":0},{"$f":"C34","v":0},{"$f":"D34","v":0},null,null,null,"4. Books and Supplies","4000-4999",null,null,null,null,null,null,"4. Books and Supplies","4000-4999"]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"+'Page 4b. Rest GF'!F32","v":0},null,null,null,null,null,"5. Services and Other Operating Expenditures","5000-5999",null,null,null,null,null,null,"5. Services and Other Operating Expenditures","5000-5999"]
["ENDING FUND BALANCE ",null,{"$f":"C30+C32+C33","v":0},{"$f":"D30+D32","v":0},{"$f":"E30+E32","v":0},null,null,null,"6. Capital Outlay","6000-6999",null,null,null,null,null,null,"6. Capital Outlay","6000-6999"]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,null,"7. Other Outgo (excluding Transfers of Indirect Costs)","7100-7299, 7400-7499",null,null,null,null,null,null,"7. Other Outgo (excluding Transfers of Indirect Costs)","7100-7299, 7400-7499"]
["     Nonspendable ","9711-9719",{"$f":"+'Page 4b. Rest GF'!F35","v":0},{"$f":"M47+U48","v":0},{"$f":"O47+W48","v":0},null,null,null,"8. Other Outgo - Transfers of Indirect Costs","7300-7399",null,null,null,null,null,null,"8. Other Outgo - Transfers of Indirect Costs","7300-7399"]
["     Restricted ",9740,{"$f":"+'Page 4b. Rest GF'!F36","v":0},{"$f":"D34-D36","v":0},{"$f":"E34-E36","v":0},null,null,null,"9. Other Financing Uses","",null,null,null,null,null,null,"9. Other Financing Uses",""]
["     Committed ","9750-9760",null,null,null,null,null,null,"a. Transfers Out","7600-7629",null,null,null,null,null,null,"a. Transfers Out","7600-7629"]
["     Assigned ",9780,null,null,null,null,null,null,"b. Other Uses","7630-7699",null,null,null,null,null,null,"b. Other Uses","7630-7699"]
["     Reserve for Economic Uncertainties",9789,{"$f":"+'Page 4b. Rest GF'!F39","v":0},null,null,null,null,null,"10. Other Adjustments (Explain in Section F below)","",null,null,null,null,null,null,"10. Other Adjustments (Explain in Section F below)",""]
["     Unassigned/Unappropriated Amount",9790,{"$f":"+'Page 4b. Rest GF'!F40","v":0},{"$f":"D34-SUM(D36:D40)","v":0},{"$f":"E34-SUM(E36:E40)","v":0},null,null,null,"11. Total (Sum lines B1 thru B10)","",null,null,null,null,null,null,"11. Total (Sum lines B1 thru B10)",""]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts must be positive ",null,null,null,null,null,"C. NET INCREASE (DECREASE) IN FUND BALANCE (Line A6 minus line B11)","",null,null,null,null,null,null,"C. NET INCREASE (DECREASE) IN FUND BALANCE",""]
[null,null,null,null,null,null,null,null,"D. FUND BALANCE","",null,null,null,null,null,null,"(Line A6 minus line B11)",""]
[null,null,null,null,null,null,null,null,"1. Net Beginning Fund Balance (Form 01, line F1e)","",null,null,null,null,null,null,"D. FUND BALANCE",""]
[null,null,null,null,null,null,null,null,"2. Ending Fund Balance (Sum lines C and D1)","",null,null,null,null,null,null,"1. Net Beginning Fund Balance (Form 01I, line F1e)",""]
[null,null,null,null,null,null,null,null,"3. Components of Ending Fund Balance","",null,null,null,null,null,null,"2. Ending Fund Balance (Sum lines C and D1)",""]
[null,null,null,null,null,null,null,null,"a. Nonspendable","9710-9719",null,null,null,null,null,null,"3. Components of Ending Fund Balance (Form 01I)",""]
[null,null,null,null,null,null,null,null,"b. Restricted","9740",null,null,null,null,null,null,"a. Nonspendable","9710-9719"]
[null,null,null,null,null,null,null,null,"c. Committed","",null,null,null,null,null,null,"b. Restricted","9740"]
[null,null,null,null,null,null,null,null,"1. Stabilization Arrangements","9750",null,null,null,null,null,null,"c. Committed",""]
[null,null,null,null,null,null,null,null,"2. Other Commitments","9760",null,null,null,null,null,null,"1. Stabilization Arrangements","9750"]
[null,null,null,null,null,null,null,null,"d. Assigned","9780",null,null,null,null,null,null,"2. Other Commitments","9760"]
[null,null,null,null,null,null,null,null,"e. Unassigned/Unappropriated","",null,null,null,null,null,null,"d. Assigned","9780"]
[null,null,null,null,null,null,null,null,"1. Reserve for Economic Uncertainties","9789",null,null,null,null,null,null,"e. Unassigned/Unappropriated",""]
[null,null,null,null,null,null,null,null,"2. Unassigned/Unappropriated","9790",null,null,null,null,null,null,"1. Reserve for Economic Uncertainties","9789"]
[null,null,null,null,null,null,null,null,"f. Total Components of Ending Fund Balance (Line D3f must agree with line D2)","",null,null,null,null,null,null,"2. Unassigned/Unappropriated","9790"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f. Total Components of Ending Fund Balance",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Line D3f must agree with line D2)",""]

{"sheet":"Page 5c MYP Combined","index":21,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[41,2,41,4],[24,0,24,1],[25,0,25,1],[29,0,29,1],[30,0,30,1],[33,0,33,1],[34,0,34,1],[6,10,6,16],[5,6,5,8],[14,0,14,1],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,1],[4,2,4,4],[5,0,5,1],[5,2,5,4],[6,0,7,0],[8,0,8,1],[13,0,13,1]]}
[{"$f":"IF('Page 1a, Cost of the agreement'!C4=0,\"\",'Page 1a, Cost of the agreement'!C4)","v":""}]
[]
["H.  IMPACT OF PROPOSED AGREEMENT ON SUBSEQUENT YEARS"]
[]
[null,null,"Combined General Fund MYP"]
[null,null,null,null,null,null,"Change from Last MYP"]
[null,null,{"$f":"+'Page 5b MYP Rest GF'!C7","v":0},{"$f":"+'Page 5b MYP Rest GF'!D7","v":{"$error":"#VALUE!"}},{"$f":"+'Page 5b MYP Rest GF'!E7","v":{"$error":"#VALUE!"}},null,{"$f":"C7","v":0},{"$f":"D7","v":{"$error":"#VALUE!"}},{"$f":"E7","v":{"$error":"#VALUE!"}},null,"Unrestricted + Restricted Board-Approved MYP"]
[null,"Object Code","Total Revised Budget After Settlement ","First Subsequent Year After Settlement","Second Subsequent Year After Settlement",null,null,null,null,null,"Description","Object\nCodes","Year 1\nBudget\n(Form 01)\n(A)","%\nChange\n(Cols. C-A/A)\n(B)","Year 2\nProjection\n(C)","%\nChange\n(Cols. E-C/C)\n(D)","Year 3\nProjection (E)"]
["REVENUES",null,null,null,null,null,null,null,null,null,null,"","","","","",""]
["     LCFF Revenue","8010-8099",{"$f":"+'Page 5a MYP Unrest GF'!C10+'Page 5b MYP Rest GF'!C10","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D10+'Page 5b MYP Rest GF'!D10","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E10+'Page 5b MYP Rest GF'!E10","v":0},null,{"$f":"C10-M10","v":0},{"$f":"D10-O10","v":0},{"$f":"E10-Q10","v":0},null,"1. LCFF/Revenue Limit Sources","8010-8099",{"$f":"'Page 5a MYP Unrest GF'!K9+'Page 5a MYP Unrest GF'!S9+'Page 5b MYP Rest GF'!K9+'Page 5b MYP Rest GF'!S9","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M9+'Page 5a MYP Unrest GF'!U9+'Page 5b MYP Rest GF'!M9+'Page 5b MYP Rest GF'!U9","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O9+'Page 5a MYP Unrest GF'!W9+'Page 5b MYP Rest GF'!O9+'Page 5b MYP Rest GF'!W9","v":0}]
["     Federal Revenue","8100-8299",{"$f":"+'Page 5a MYP Unrest GF'!C11+'Page 5b MYP Rest GF'!C11","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D11+'Page 5b MYP Rest GF'!D11","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E11+'Page 5b MYP Rest GF'!E11","v":0},null,{"$f":"C11-M11","v":0},{"$f":"D11-O11","v":0},{"$f":"E11-Q11","v":0},null,"2. Federal Revenues","8100-8299",{"$f":"'Page 5a MYP Unrest GF'!K10+'Page 5a MYP Unrest GF'!S10+'Page 5b MYP Rest GF'!K10+'Page 5b MYP Rest GF'!S10","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M10+'Page 5a MYP Unrest GF'!U10+'Page 5b MYP Rest GF'!M10+'Page 5b MYP Rest GF'!U10","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O10+'Page 5a MYP Unrest GF'!W10+'Page 5b MYP Rest GF'!O10+'Page 5b MYP Rest GF'!W10","v":0}]
["     Other State Revenue","8300-8599",{"$f":"+'Page 5a MYP Unrest GF'!C12+'Page 5b MYP Rest GF'!C12","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D12+'Page 5b MYP Rest GF'!D12","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E12+'Page 5b MYP Rest GF'!E12","v":0},null,0,0,0,null,"3. Other State Revenues","8300-8599",{"$f":"'Page 5a MYP Unrest GF'!K11+'Page 5a MYP Unrest GF'!S11+'Page 5b MYP Rest GF'!K11+'Page 5b MYP Rest GF'!S11","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M11+'Page 5a MYP Unrest GF'!U11+'Page 5b MYP Rest GF'!M11+'Page 5b MYP Rest GF'!U11","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O11+'Page 5a MYP Unrest GF'!W11+'Page 5b MYP Rest GF'!O11+'Page 5b MYP Rest GF'!W11","v":0}]
["     Other Local Revenue","8600-8799",{"$f":"+'Page 5a MYP Unrest GF'!C13+'Page 5b MYP Rest GF'!C13","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D13+'Page 5b MYP Rest GF'!D13","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E13+'Page 5b MYP Rest GF'!E13","v":0},null,0,0,0,null,"4. Other Local Revenues","8600-8799",{"$f":"'Page 5a MYP Unrest GF'!K12+'Page 5a MYP Unrest GF'!S12+'Page 5b MYP Rest GF'!K12+'Page 5b MYP Rest GF'!S12","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M12+'Page 5a MYP Unrest GF'!U12+'Page 5b MYP Rest GF'!M12+'Page 5b MYP Rest GF'!U12","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O12+'Page 5a MYP Unrest GF'!W12+'Page 5b MYP Rest GF'!O12+'Page 5b MYP Rest GF'!W12","v":0}]
["TOTAL REVENUES",null,{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0},null,{"$f":"SUM(G10:G13)","v":0},{"$f":"SUM(H10:H13)","v":0},0,null,"5. Other Financing Sources",""]
["EXPENDITURES",null,null,null,null,null,null,null,null,null,"a. Transfers In","8900-8929",{"$f":"'Page 5a MYP Unrest GF'!K14+'Page 5a MYP Unrest GF'!S14+'Page 5b MYP Rest GF'!K14+'Page 5b MYP Rest GF'!S14","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M14+'Page 5a MYP Unrest GF'!U14+'Page 5b MYP Rest GF'!M14+'Page 5b MYP Rest GF'!U14","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O14+'Page 5a MYP Unrest GF'!W14+'Page 5b MYP Rest GF'!O14+'Page 5b MYP Rest GF'!W14","v":0}]
["     Certificated Salaries ","1000-1999",{"$f":"+'Page 5a MYP Unrest GF'!C16+'Page 5b MYP Rest GF'!C16","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D16+'Page 5b MYP Rest GF'!D16","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E16+'Page 5b MYP Rest GF'!E16","v":0},null,{"$f":"C16-M25","v":0},{"$f":"D16-O25","v":0},{"$f":"E16-Q25","v":0},null,"b. Other Sources","8930-8979",{"$f":"'Page 5a MYP Unrest GF'!K15+'Page 5a MYP Unrest GF'!S15+'Page 5b MYP Rest GF'!K15+'Page 5b MYP Rest GF'!S15","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M15+'Page 5a MYP Unrest GF'!U15+'Page 5b MYP Rest GF'!M15+'Page 5b MYP Rest GF'!U15","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O15+'Page 5a MYP Unrest GF'!W15+'Page 5b MYP Rest GF'!O15+'Page 5b MYP Rest GF'!W15","v":0}]
["     Classified Salaries","2000-2999",{"$f":"+'Page 5a MYP Unrest GF'!C17+'Page 5b MYP Rest GF'!C17","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D17+'Page 5b MYP Rest GF'!D17","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E17+'Page 5b MYP Rest GF'!E17","v":0},null,{"$f":"C17-M31","v":0},{"$f":"D17-O31","v":0},{"$f":"E17-Q31","v":0},null,"c. Contributions","8980-8999",{"$f":"'Page 5a MYP Unrest GF'!K16+'Page 5a MYP Unrest GF'!S16+'Page 5b MYP Rest GF'!K16+'Page 5b MYP Rest GF'!S16","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M16+'Page 5a MYP Unrest GF'!U16+'Page 5b MYP Rest GF'!M16+'Page 5b MYP Rest GF'!U16","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O16+'Page 5a MYP Unrest GF'!W16+'Page 5b MYP Rest GF'!O16+'Page 5b MYP Rest GF'!W16","v":0}]
["     Employee Benefits","3000-3999",{"$f":"+'Page 5a MYP Unrest GF'!C18+'Page 5b MYP Rest GF'!C18","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D18+'Page 5b MYP Rest GF'!D18","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E18+'Page 5b MYP Rest GF'!E18","v":0},null,0,0,0,null,"6. Total (Sum lines A1 thru A5c)","",{"$f":"SUM(M10:M17)","v":0},null,{"$f":"SUM(O10:O17)","v":0},null,0]
["     Books and Supplies","4000-4999",{"$f":"+'Page 5a MYP Unrest GF'!C19+'Page 5b MYP Rest GF'!C19","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D19+'Page 5b MYP Rest GF'!D19","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E19+'Page 5b MYP Rest GF'!E19","v":0},null,0,0,0,null,"B. EXPENDITURES AND OTHER FINANCING USES",""]
["     Services and Other Operating Expenditures","5000-5999",{"$f":"+'Page 5a MYP Unrest GF'!C20+'Page 5b MYP Rest GF'!C20","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D20+'Page 5b MYP Rest GF'!D20","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E20+'Page 5b MYP Rest GF'!E20","v":0},null,0,0,0,null,"1. Certificated Salaries",""]
["     Capital Outlay","6000-6999",{"$f":"+'Page 5a MYP Unrest GF'!C21+'Page 5b MYP Rest GF'!C21","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D21+'Page 5b MYP Rest GF'!D21","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E21+'Page 5b MYP Rest GF'!E21","v":0},null,0,0,0,null,"a. Base Salaries",""]
["     Other Outgo (excuding Indirect Costs)","7100-7299  7400-7499",{"$f":"+'Page 5a MYP Unrest GF'!C22+'Page 5b MYP Rest GF'!C22","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D22+'Page 5b MYP Rest GF'!D22","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E22+'Page 5b MYP Rest GF'!E22","v":0},null,0,0,0,null,"b. Step & Column Adjustment",""]
["     Transfers of Indirect Costs","7300-7399",{"$f":"+'Page 5a MYP Unrest GF'!C23+'Page 5b MYP Rest GF'!C23","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D23+'Page 5b MYP Rest GF'!D23","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E23+'Page 5b MYP Rest GF'!E23","v":0},null,0,0,0,null,"c. Cost-of-Living Adjustment",""]
["     Other Adjustments",null,{"$f":"+'Page 5a MYP Unrest GF'!C24+'Page 5b MYP Rest GF'!C24","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D24+'Page 5b MYP Rest GF'!D24","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E24+'Page 5b MYP Rest GF'!E24","v":0},null,null,{"$f":"D24-O41","v":0},{"$f":"E24-Q41","v":0},null,"d. Other Adjustments",""]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},null,{"$f":"SUM(G16:G24)","v":0},{"$f":"SUM(H16:H24)","v":0},0,null,"e. Total Certificated Salaries (Sum lines B1a thru B1d)","1000-1999",{"$f":"'Page 5a MYP Unrest GF'!K24+'Page 5a MYP Unrest GF'!S24+'Page 5b MYP Rest GF'!K24+'Page 5b MYP Rest GF'!S24","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M24+'Page 5a MYP Unrest GF'!U24+'Page 5b MYP Rest GF'!M24+'Page 5b MYP Rest GF'!U24","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O24+'Page 5a MYP Unrest GF'!W24+'Page 5b MYP Rest GF'!O24+'Page 5b MYP Rest GF'!W24","v":0}]
["OTHER FINANCING SOURCES/USES",null,null,null,null,null,null,null,null,null,"2. Classified Salaries",""]
["     Transfers In and Other Sources","8900-8979",{"$f":"+'Page 5a MYP Unrest GF'!C27+'Page 5b MYP Rest GF'!C27","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D27+'Page 5b MYP Rest GF'!D27","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E27+'Page 5b MYP Rest GF'!E27","v":0},null,{"$f":"C27-M15-M16","v":0},{"$f":"D27-O15-O16","v":0},{"$f":"E27-Q15-Q16","v":0},null,"a. Base Salaries",""]
["     Transfers Out and Other Uses","7600-7699",{"$f":"+'Page 5a MYP Unrest GF'!C28+'Page 5b MYP Rest GF'!C28","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D28+'Page 5b MYP Rest GF'!D28","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E28+'Page 5b MYP Rest GF'!E28","v":0},null,{"$f":"C28-M39-M40","v":0},{"$f":"D28-O39-O40","v":0},{"$f":"E28-Q39-Q40","v":0},null,"b. Step & Column Adjustment",""]
["     Contributions","8980-8999",{"$f":"+'Page 5a MYP Unrest GF'!C29+'Page 5b MYP Rest GF'!C29","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D29+'Page 5b MYP Rest GF'!D29","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E29+'Page 5b MYP Rest GF'!E29","v":0},null,{"$f":"C29-M17","v":0},{"$f":"D29-O17","v":0},{"$f":"E29-Q17","v":0},null,"c. Cost-of-Living Adjustment",""]
["OPERATING SURPLUS (DEFICIT)*",null,{"$f":"C14-C25+C27-C28+C29","v":0},{"$f":"D14-D25+D27-D28+D29","v":0},{"$f":"E14-E25+E27-E28+E29","v":0},null,{"$f":"G14-G25+G27-G28+G29","v":0},{"$f":"H14-H25+H27-H28+H29","v":0},0,null,"d. Other Adjustments",""]
[null,null,null,null,null,null,null,null,null,null,"e. Total Classified Salaries (Sum lines B2a thru B2d)","2000-2999",{"$f":"'Page 5a MYP Unrest GF'!K30+'Page 5a MYP Unrest GF'!S30+'Page 5b MYP Rest GF'!K30+'Page 5b MYP Rest GF'!S30","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M30+'Page 5a MYP Unrest GF'!U30+'Page 5b MYP Rest GF'!M30+'Page 5b MYP Rest GF'!U30","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O30+'Page 5a MYP Unrest GF'!W30+'Page 5b MYP Rest GF'!O30+'Page 5b MYP Rest GF'!W30","v":0}]
["BEGINNING FUND BALANCE ",9791,{"$f":"+'Page 5a MYP Unrest GF'!C32+'Page 5b MYP Rest GF'!C32","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D32+'Page 5b MYP Rest GF'!D32","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E32+'Page 5b MYP Rest GF'!E32","v":0},null,{"$f":"C32-M45","v":0},{"$f":"D32-O45","v":0},{"$f":"E32-Q45","v":0},null,"3. Employee Benefits","3000-3999",{"$f":"'Page 5a MYP Unrest GF'!K31+'Page 5a MYP Unrest GF'!S31+'Page 5b MYP Rest GF'!K31+'Page 5b MYP Rest GF'!S31","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M31+'Page 5a MYP Unrest GF'!U31+'Page 5b MYP Rest GF'!M31+'Page 5b MYP Rest GF'!U31","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O31+'Page 5a MYP Unrest GF'!W31+'Page 5b MYP Rest GF'!O31+'Page 5b MYP Rest GF'!W31","v":0}]
["    Audit Adjustments/Other Restatements","9793/9795",{"$f":"+'Page 5a MYP Unrest GF'!C33+'Page 5b MYP Rest GF'!C33","v":0},null,null,null,null,null,null,null,"4. Books and Supplies","4000-4999",{"$f":"'Page 5a MYP Unrest GF'!K32+'Page 5a MYP Unrest GF'!S32+'Page 5b MYP Rest GF'!K32+'Page 5b MYP Rest GF'!S32","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M32+'Page 5a MYP Unrest GF'!U32+'Page 5b MYP Rest GF'!M32+'Page 5b MYP Rest GF'!U32","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O32+'Page 5a MYP Unrest GF'!W32+'Page 5b MYP Rest GF'!O32+'Page 5b MYP Rest GF'!W32","v":0}]
["ENDING FUND BALANCE ",null,{"$f":"C30+C32+C33","v":0},{"$f":"D30+D32","v":0},{"$f":"E30+E32","v":0},null,{"$f":"C34-M46","v":0},{"$f":"D34-O46","v":0},{"$f":"E34-Q46","v":0},null,"5. Services and Other Operating Expenditures","5000-5999",{"$f":"'Page 5a MYP Unrest GF'!K33+'Page 5a MYP Unrest GF'!S33+'Page 5b MYP Rest GF'!K33+'Page 5b MYP Rest GF'!S33","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M33+'Page 5a MYP Unrest GF'!U33+'Page 5b MYP Rest GF'!M33+'Page 5b MYP Rest GF'!U33","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O33+'Page 5a MYP Unrest GF'!W33+'Page 5b MYP Rest GF'!O33+'Page 5b MYP Rest GF'!W33","v":0}]
["COMPONENTS OF ENDING FUND BALANCE:",null,null,null,null,null,null,null,null,null,"6. Capital Outlay","6000-6999",{"$f":"'Page 5a MYP Unrest GF'!K34+'Page 5a MYP Unrest GF'!S34+'Page 5b MYP Rest GF'!K34+'Page 5b MYP Rest GF'!S34","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M34+'Page 5a MYP Unrest GF'!U34+'Page 5b MYP Rest GF'!M34+'Page 5b MYP Rest GF'!U34","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O34+'Page 5a MYP Unrest GF'!W34+'Page 5b MYP Rest GF'!O34+'Page 5b MYP Rest GF'!W34","v":0}]
["     Nonspendable ","9711-9719",{"$f":"+'Page 5a MYP Unrest GF'!C36+'Page 5b MYP Rest GF'!C36","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D36+'Page 5b MYP Rest GF'!D36","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E36+'Page 5b MYP Rest GF'!E36","v":0},null,{"$f":"C36-M48","v":0},{"$f":"D36-O48","v":0},{"$f":"E36-Q48","v":0},null,"7. Other Outgo (excluding Transfers of Indirect Costs)","7100-7299, 7400-7499",{"$f":"'Page 5a MYP Unrest GF'!K35+'Page 5a MYP Unrest GF'!S35+'Page 5b MYP Rest GF'!K35+'Page 5b MYP Rest GF'!S35","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M35+'Page 5a MYP Unrest GF'!U35+'Page 5b MYP Rest GF'!M35+'Page 5b MYP Rest GF'!U35","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O35+'Page 5a MYP Unrest GF'!W35+'Page 5b MYP Rest GF'!O35+'Page 5b MYP Rest GF'!W35","v":0}]
["     Restricted ",9740,{"$f":"+'Page 5a MYP Unrest GF'!C37+'Page 5b MYP Rest GF'!C37","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D37+'Page 5b MYP Rest GF'!D37","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E37+'Page 5b MYP Rest GF'!E37","v":0},null,{"$f":"C37-M49","v":0},{"$f":"D37-O49","v":0},{"$f":"E37-Q49","v":0},null,"8. Other Outgo - Transfers of Indirect Costs","7300-7399",{"$f":"'Page 5a MYP Unrest GF'!K36+'Page 5a MYP Unrest GF'!S36+'Page 5b MYP Rest GF'!K36+'Page 5b MYP Rest GF'!S36","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M36+'Page 5a MYP Unrest GF'!U36+'Page 5b MYP Rest GF'!M36+'Page 5b MYP Rest GF'!U36","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O36+'Page 5a MYP Unrest GF'!W36+'Page 5b MYP Rest GF'!O36+'Page 5b MYP Rest GF'!W36","v":0}]
["     Committed ","9750-9760",{"$f":"+'Page 5a MYP Unrest GF'!C38+'Page 5b MYP Rest GF'!C38","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D38+'Page 5b MYP Rest GF'!D38","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E38+'Page 5b MYP Rest GF'!E38","v":0},null,{"$f":"C38-M51-M52","v":0},{"$f":"D38-O51-O52","v":0},{"$f":"E38-Q51-Q52","v":0},null,"9. Other Financing Uses",""]
["     Assigned ",9780,{"$f":"+'Page 5a MYP Unrest GF'!C39+'Page 5b MYP Rest GF'!C39","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D39+'Page 5b MYP Rest GF'!D39","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E39+'Page 5b MYP Rest GF'!E39","v":0},null,{"$f":"C39-M53","v":0},{"$f":"D39-O53","v":0},{"$f":"E39-Q53","v":0},null,"a. Transfers Out","7600-7629",{"$f":"'Page 5a MYP Unrest GF'!K38+'Page 5a MYP Unrest GF'!S38+'Page 5b MYP Rest GF'!K38+'Page 5b MYP Rest GF'!S38","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M38+'Page 5a MYP Unrest GF'!U38+'Page 5b MYP Rest GF'!M38+'Page 5b MYP Rest GF'!U38","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O38+'Page 5a MYP Unrest GF'!W38+'Page 5b MYP Rest GF'!O38+'Page 5b MYP Rest GF'!W38","v":0}]
["     Reserve for Economic Uncertainties",9789,{"$f":"+'Page 5a MYP Unrest GF'!C40+'Page 5b MYP Rest GF'!C40","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D40+'Page 5b MYP Rest GF'!D40","v":0},{"$f":"+'Page 5a MYP Unrest GF'!E40+'Page 5b MYP Rest GF'!E40","v":0},null,{"$f":"C40-M55","v":0},{"$f":"D40-O55","v":0},{"$f":"E40-Q55","v":0},null,"b. Other Uses","7630-7699",{"$f":"'Page 5a MYP Unrest GF'!K39+'Page 5a MYP Unrest GF'!S39+'Page 5b MYP Rest GF'!K39+'Page 5b MYP Rest GF'!S39","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M39+'Page 5a MYP Unrest GF'!U39+'Page 5b MYP Rest GF'!M39+'Page 5b MYP Rest GF'!U39","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O39+'Page 5a MYP Unrest GF'!W39+'Page 5b MYP Rest GF'!O39+'Page 5b MYP Rest GF'!W39","v":0}]
["     Unassigned/Unappropriated Amount",9790,{"$f":"C34-SUM(C36:C40)","v":0},{"$f":"D34-SUM(D36:D40)","v":0},{"$f":"E34-SUM(E36:E40)","v":0},null,{"$f":"C41-M56","v":0},{"$f":"D41-O56","v":0},{"$f":"E41-Q56","v":0},null,"10. Other Adjustments","",{"$f":"'Page 5a MYP Unrest GF'!K40+'Page 5a MYP Unrest GF'!S40+'Page 5b MYP Rest GF'!K40+'Page 5b MYP Rest GF'!S40","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M40+'Page 5a MYP Unrest GF'!U40+'Page 5b MYP Rest GF'!M40+'Page 5b MYP Rest GF'!U40","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O40+'Page 5a MYP Unrest GF'!W40+'Page 5b MYP Rest GF'!O40+'Page 5b MYP Rest GF'!W40","v":0}]
["*Net Increase (Decrease) in Fund Balance",null,"NOTE: 9790 amounts must be positive ",null,null,null,null,null,null,null,"11. Total (Sum lines B1 thru B10)","",{"$f":"'Page 5a MYP Unrest GF'!K41+'Page 5a MYP Unrest GF'!S41+'Page 5b MYP Rest GF'!K41+'Page 5b MYP Rest GF'!S41","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M41+'Page 5a MYP Unrest GF'!U41+'Page 5b MYP Rest GF'!M41+'Page 5b MYP Rest GF'!U41","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O41+'Page 5a MYP Unrest GF'!W41+'Page 5b MYP Rest GF'!O41+'Page 5b MYP Rest GF'!W41","v":0}]
[null,null,null,null,null,null,null,null,null,null,"C. NET INCREASE (DECREASE) IN FUND BALANCE (Line A6 minus line B11)","",{"$f":"'Page 5a MYP Unrest GF'!K42+'Page 5a MYP Unrest GF'!S42+'Page 5b MYP Rest GF'!K42+'Page 5b MYP Rest GF'!S42","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M42+'Page 5a MYP Unrest GF'!U42+'Page 5b MYP Rest GF'!M42+'Page 5b MYP Rest GF'!U42","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O42+'Page 5a MYP Unrest GF'!W42+'Page 5b MYP Rest GF'!O42+'Page 5b MYP Rest GF'!W42","v":0}]
[null,null,null,null,null,null,null,null,null,null,"D. FUND BALANCE",""]
[null,null,null,null,null,null,null,null,null,null,"1. Net Beginning Fund Balance (Form 01, line F1e)","",{"$f":"'Page 5a MYP Unrest GF'!K44+'Page 5a MYP Unrest GF'!S44+'Page 5b MYP Rest GF'!K44+'Page 5b MYP Rest GF'!S44","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M44+'Page 5a MYP Unrest GF'!U44+'Page 5b MYP Rest GF'!M44+'Page 5b MYP Rest GF'!U44","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O44+'Page 5a MYP Unrest GF'!W44+'Page 5b MYP Rest GF'!O44+'Page 5b MYP Rest GF'!W44","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2. Ending Fund Balance (Sum lines C and D1)","",{"$f":"'Page 5a MYP Unrest GF'!K45+'Page 5a MYP Unrest GF'!S45+'Page 5b MYP Rest GF'!K45+'Page 5b MYP Rest GF'!S45","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M45+'Page 5a MYP Unrest GF'!U45+'Page 5b MYP Rest GF'!M45+'Page 5b MYP Rest GF'!U45","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O45+'Page 5a MYP Unrest GF'!W45+'Page 5b MYP Rest GF'!O45+'Page 5b MYP Rest GF'!W45","v":0}]
[null,null,null,null,null,null,null,null,null,null,"3. Components of Ending Fund Balance",""]
[null,null,null,null,null,null,null,null,null,null,"a. Nonspendable","9710-9719",{"$f":"'Page 5a MYP Unrest GF'!K47+'Page 5a MYP Unrest GF'!S47+'Page 5b MYP Rest GF'!K47+'Page 5b MYP Rest GF'!S47","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M47+'Page 5a MYP Unrest GF'!U47+'Page 5b MYP Rest GF'!M47+'Page 5b MYP Rest GF'!U47","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O47+'Page 5a MYP Unrest GF'!W47+'Page 5b MYP Rest GF'!O47+'Page 5b MYP Rest GF'!W47","v":0}]
[null,null,null,null,null,null,null,null,null,null,"b. Restricted","9740",{"$f":"'Page 5b MYP Rest GF'!K48+'Page 5b MYP Rest GF'!S49","v":0},null,{"$f":"'Page 5b MYP Rest GF'!M48+'Page 5b MYP Rest GF'!U49","v":0},null,{"$f":"'Page 5b MYP Rest GF'!O48+'Page 5b MYP Rest GF'!W49","v":0}]
[null,null,null,null,null,null,null,null,null,null,"c. Committed",""]
[null,null,null,null,null,null,null,null,null,null,"1. Stabilization Arrangements","9750",{"$f":"'Page 5a MYP Unrest GF'!K59+'Page 5a MYP Unrest GF'!S61","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M59+'Page 5a MYP Unrest GF'!U61","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O59+'Page 5a MYP Unrest GF'!W61","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2. Other Commitments","9760",{"$f":"'Page 5a MYP Unrest GF'!K51+'Page 5a MYP Unrest GF'!S52","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M51+'Page 5a MYP Unrest GF'!U52","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O51+'Page 5a MYP Unrest GF'!W52","v":0}]
[null,null,null,null,null,null,null,null,null,null,"d. Assigned","9780",{"$f":"'Page 5a MYP Unrest GF'!K52+'Page 5a MYP Unrest GF'!S53","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M52+'Page 5a MYP Unrest GF'!U53","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O52+'Page 5a MYP Unrest GF'!W53","v":0}]
[null,null,null,null,null,null,null,null,null,null,"e. Unassigned/Unappropriated",""]
[null,null,null,null,null,null,null,null,null,null,"1. Reserve for Economic Uncertainties","9789",{"$f":"'Page 5a MYP Unrest GF'!K54+'Page 5a MYP Unrest GF'!S55","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M54+'Page 5a MYP Unrest GF'!U55","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O54+'Page 5a MYP Unrest GF'!W55","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2. Unassigned/Unappropriated","9790",{"$f":"'Page 5a MYP Unrest GF'!K55+'Page 5a MYP Unrest GF'!S56+'Page 5b MYP Rest GF'!K55+'Page 5b MYP Rest GF'!S56","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!M55+'Page 5a MYP Unrest GF'!U56+'Page 5b MYP Rest GF'!M55+'Page 5b MYP Rest GF'!U56","v":0},null,{"$f":"'Page 5a MYP Unrest GF'!O55+'Page 5a MYP Unrest GF'!W56+'Page 5b MYP Rest GF'!O55+'Page 5b MYP Rest GF'!W56","v":0}]
[null,null,null,null,null,null,null,null,null,null,"f. Total Components of Ending Fund Balance (Line D3f must agree with line D2)","",{"$f":"M48+M49+M50+M53+M54","v":0},null,{"$f":"O48+O49+O50+O53+O54","v":0},null,{"$f":"Q48+Q49+Q50+Q53+Q54","v":0}]

{"sheet":"Page 6, Reserve Levels","index":22,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,6],[29,0,29,6],[30,0,30,6],[20,3,20,4],[20,5,20,6],[21,3,21,4],[21,5,21,6],[22,0,22,6],[23,3,23,6],[17,3,17,4],[17,5,17,6],[18,3,18,4],[18,5,18,6],[19,3,19,4],[19,5,19,6],[16,3,16,4],[16,5,16,6],[9,3,9,4],[9,5,9,6],[10,3,10,4],[10,5,10,6],[11,3,11,4],[11,5,11,6],[12,3,12,4],[12,5,12,6],[13,0,13,6],[14,1,14,6],[15,0,15,6],[8,3,8,4],[8,5,8,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,1,5,6],[6,0,6,1],[6,3,6,4],[6,5,6,6],[7,3,7,4],[7,5,7,6]]}
[]
[]
[]
["I.  IMPACT OF PROPOSED AGREEMENT ON UNRESTRICTED RESERVES",null,null,null,null,null,null,null,"Section I, Pages 6 and 7: Impact of Proposed Agreement on Unrestricted Reserves"]
[]
[{"$f":"\"1.\"","v":"1."},"State Reserve Standard"]
[null,null,{"$f":"+'Page 5c MYP Combined'!C7","v":0},{"$f":"+'Page 5c MYP Combined'!D7","v":{"$error":"#VALUE!"}},null,{"$f":"+'Page 5c MYP Combined'!E7","v":{"$error":"#VALUE!"}}]
["a.","Total Expenditures, Transfers Out, and Uses (Including Cost of Proposed Agreement)",{"$f":"+'Page 5c MYP Combined'!C28+'Page 5c MYP Combined'!C25","v":0},{"$f":"+'Page 5c MYP Combined'!D25+'Page 5c MYP Combined'!D28","v":0},null,{"$f":"+'Page 5c MYP Combined'!E25+'Page 5c MYP Combined'!E28","v":0}]
["b.","Less:  Special Education Pass-Through Funds",0,0,null,0]
["c.","Net Expenditures, Transfers Out, and Uses",{"$f":"C8-C9","v":0},{"$f":"D8-D9","v":0},null,{"$f":"F8-F9","v":0}]
["d.","Projected P-2 ADA"]
["e.","State Standard Minimum Reserve Percentage for this District                      ",{"$f":"IF(C11>=400001,1%,IF(C11>=30001,2%,IF(C11>=1001,3%,IF(C11>=301,4%,IF(C11>0,5%,\"\")))))","v":""},{"$f":"IF(D11>=400001,1%,IF(D11>=30001,2%,IF(D11>=1001,3%,IF(D11>=301,4%,IF(D11>0,5%,\"\")))))","v":""},"",{"$f":"IF(F11>=400001,1%,IF(F11>=30001,2%,IF(F11>=1001,3%,IF(F11>=301,4%,IF(F11>0,5%,\"\")))))","v":""},""]
["f.","State Standard Minimum Reserve Amount for this District (For districts with less than 1,001 ADA, this is the greater of Line a, times Line b, or the minimum amount specified in the current year Criteria and Standards)",{"$f":"IF(C8>0,(MAX((C10*C12),69000,0)),\"\")","v":""},{"$f":"IF(D8>0,(MAX((D10*D12),69000,0)),\"\")","v":""},"","",""]
[]
[{"$f":"\"2.\"","v":"2."},"Budgeted Unrestricted Reserve (After Impact of Proposed Agreement)"]
[]
["a.","General Fund Budgeted Unrestricted       Designated for Economic Uncertainties (9789)",{"$f":"+'Page 5a MYP Unrest GF'!C40","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D40","v":0},null,{"$f":"+'Page 5a MYP Unrest GF'!E40","v":0}]
["b.","General Fund Budgeted Unrestricted Unassigned/Unappropriated Amount (9790)",{"$f":"+'Page 5a MYP Unrest GF'!C41","v":0},{"$f":"+'Page 5a MYP Unrest GF'!D41","v":0},null,{"$f":"+'Page 5a MYP Unrest GF'!E41","v":0}]
["c.","Special Reserve Fund (Fund 17) Budgeted Designated for Economic Uncertainties (9789)",0,0,null,0]
["d.","Special Reserve Fund (Fund 17) Budgeted Unassigned/Unappropriated Amount (9790)",0,0,null,0]
["e.","Total Available Reserves",{"$f":"SUM(C17:C20)","v":0},{"$f":"SUM(D17:E20)","v":0},null,{"$f":"SUM(F17:G20)","v":0}]
["f.","Reserve for Economic Uncertainties Percentage",{"$f":"IF(C10=0,0,ROUND(C21/C10,4))","v":0},{"$f":"IF(D10=0,0,ROUND(D21/D10,4))","v":0},null,{"$f":"IF(F10=0,0,ROUND(F21/F10,4))","v":0}]
[]
[{"$f":"\"3.\"","v":"3."},"Do unrestricted reserves meet the state minimum reserve amount?"]
[null,null,{"$f":"+'Page 5c MYP Combined'!C7","v":0},"Yes   ",{"$f":"IF(C22>=C12,\"X\",IF(C22<C12,\" \"))","v":" "},"No   ",{"$f":"IF(C22<C12,\"X\",IF(C22>=C12,\" \"))","v":"X"}]
[null,null,{"$f":"+'Page 5c MYP Combined'!D7","v":{"$error":"#VALUE!"}},"Yes   ",{"$f":"IF(D22>=D12,\"X\",IF(D22<D12,\" \"))","v":" "},"No   ",{"$f":"IF(D22<D12,\"X\",IF(D22>=D12,\" \"))","v":"X"}]
[null,null,{"$f":"+'Page 5c MYP Combined'!E7","v":{"$error":"#VALUE!"}},"Yes   ",{"$f":"IF(F22>=F12,\"X\",IF(F22<F12,\" \"))","v":" "},"No   ",{"$f":"IF(F22<F12,\"X\",IF(F22>=F12,\" \"))","v":"X"}]
[]
[{"$f":"\"4.\"","v":"4."},"If no, how do you plan to restore your reserves?"]

{"sheet":"Page 7, Variance & Deficits","index":23,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,1,3,7],[0,1,0,9],[1,1,1,9],[2,1,2,9],[15,0,15,9],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,9],[12,1,12,7],[13,1,13,9],[14,1,14,9],[16,1,16,9],[17,1,17,9],[18,1,18,4],[18,7,18,9],[19,1,19,4],[19,7,19,9],[28,1,28,9],[20,1,20,4],[20,7,20,9],[21,1,21,4],[21,7,21,9],[22,1,22,4],[22,7,22,9],[23,1,23,9],[24,1,24,9],[25,0,25,9],[26,1,26,9],[27,1,27,9],[29,1,29,2],[29,3,29,4],[29,5,29,9],[30,1,30,2],[30,3,30,4],[30,5,30,9],[33,1,33,2],[33,3,33,4],[33,5,33,9],[31,1,31,2],[31,3,31,4],[31,5,31,9],[32,1,32,2],[32,3,32,4],[32,5,32,9]]}
[]
[{"$f":"\"5.\"","v":"5."},"Does the Total Compensation Increase/(Decrease) on Page 1, Section A, #5 agree with the Total Increase/(Decrease) for all funds as a result of the settlement(s)?  Please explain any variance. ",null,null,null,null,null,null,null,null,null,"Section I, Pages 6 and 7: Impact of Proposed Agreement on Unrestricted Reserves"]
[]
[null,"Total Compensation Increase/(Decrease) on Page 1, Section A, #5",null,null,null,null,null,null,{"$f":"'Page 1 Total - All Agreements'!E26","v":0}]
[null,"General Fund balance Increase/(Decrease), Page 4c, Column 2",null,null,null,null,null,null,{"$f":"'Page 4c Combined GF'!D29","v":0}]
[null,"Adult Education Fund balance Increase/(Decrease), Page 4d, Column 2",null,null,null,null,null,null,{"$f":"'Page 4d Adult Education Fund'!D27","v":0}]
[null,"Child Development Fund balance Increase/(Decrease), Page 4e, Column 2",null,null,null,null,null,null,{"$f":"'Page 4e Child Development Fund'!D27","v":0}]
[null,"Cafeteria Fund balance Increase/(Decrease), Page 4f, Column 2",null,null,null,null,null,null,{"$f":"'Page 4f Cafeteria Fund'!D27","v":0}]
[null,"Other Fund balance Increase/(Decrease), Page 4g, Column 2",null,null,null,null,null,null,{"$f":"'Page 4g Other Enterprise Fund'!D27","v":0}]
[null,"Other Fund balance Increase/(Decrease), Page 4h, Column 2",null,null,null,null,null,null,{"$f":"'Page 4h Other Fund'!D27","v":0}]
[null,"Total all fund balances Increase/(Decrease) as a result of the settlement(s)",null,null,null,null,null,null,{"$f":"SUM(I5:I10)","v":0}]
[]
[null,"Variance",null,null,null,null,null,null,{"$f":"I4+I11","v":0}]
[null,"Variance Explanation:"]
[]
[]
["6.","Will this agreement create or increase deficit financing in the current or subsequent years?"]
[null,"\"Deficit Financing\" is defined to exist when a fund's expenditures and other financing uses exceed its revenues and other financing sources in a given year.  If a deficit is shown below, provide an explanation and any deficit reduction plan, as necessary."]
[null,"General Fund Combined",null,null,null,"Surplus/ (Deficit)","(Deficit) %","Deficit primarily due to:"]
[null,"Current FY Surplus/(Deficit) before settlement(s)?",null,null,null,{"$f":"'Page 4c Combined GF'!C29","v":0},{"$f":"F20/SUM('Page 4c Combined GF'!C24+'Page 4c Combined GF'!C27+'Page 4c Combined GF'!C28)","v":{"$error":"#DIV/0!"}}]
[null,"Current FY Surplus/(Deficit) after settlement(s)?",null,null,null,{"$f":"'Page 5c MYP Combined'!C30","v":0},{"$f":"F21/SUM('Page 4c Combined GF'!F24+'Page 4c Combined GF'!F27+'Page 4c Combined GF'!F28)","v":{"$error":"#DIV/0!"}}]
[null,"1st Subsequent FY Surplus/(Deficit) after settlement(s)?",null,null,null,{"$f":"'Page 5c MYP Combined'!D30","v":0},{"$f":"F22/SUM('Page 5c MYP Combined'!D25+'Page 5c MYP Combined'!D28+'Page 5c MYP Combined'!D29)","v":{"$error":"#DIV/0!"}}]
[null,"2nd Subsequent FY Surplus/(Deficit) after settlement(s)?",null,null,null,{"$f":"'Page 5c MYP Combined'!E30","v":0},{"$f":"F23/SUM('Page 5c MYP Combined'!E25+'Page 5c MYP Combined'!E28+'Page 5c MYP Combined'!E29)","v":{"$error":"#DIV/0!"}}]
[null,"Deficit Reduction Plan (as necessary):"]
[]
[]
["7.","Were \"Other Adjustments\" amount(s) entered in the multiyear projections (pages 5a and 5b) for 1st and 2nd Subsequent FY? "]
[]
[null,"\"Other Adjustments\" could indicate that a budget reduction plan was/is being developed to address deficit spending, and to rebuild reserves.  Any amount shown below must have an explanation.  If additional space is needed, attach a separate sheet, or use page 9a.  "]
[null,"MYP",null,"Amount",null,"\"Other Adjustments\" Explanation"]
[null,"1st Subsequent FY Unrestricted, Page 5a",null,{"$f":"'Page 5a MYP Unrest GF'!D24","v":0}]
[null,"1st Subsequent FY Restricted, Page 5b",null,{"$f":"'Page 5b MYP Rest GF'!D24","v":0}]
[null,"2nd Subsequent FY Unrestricted, Page 5a",null,{"$f":"'Page 5a MYP Unrest GF'!E24","v":0}]
[null,"2nd Subsequent FY Restricted, Page 5b",null,{"$f":"'Page 5b MYP Rest GF'!E24","v":0}]

{"sheet":"Page 8, Certification","index":24,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,1,3,6],[1,0,1,6],[0,2,0,6],[2,1,2,6],[35,4,35,6],[29,2,29,6],[30,2,30,6],[35,2,35,3],[4,1,4,6],[16,1,16,6],[18,1,18,6],[19,2,20,2],[19,4,20,6],[17,1,17,6],[22,2,22,6],[34,2,34,4],[34,5,34,6],[16,8,17,8],[23,2,23,6],[6,2,6,3],[26,4,26,6],[27,0,27,6],[28,4,28,6]]}
[null,"J.","CERTIFICATION OF THE DISTRICT'S ABILITY TO MEET THE COSTS OF THE COLLECTIVE BARGAINING AGREEMENT",null,null,null,null,null,"Section J, Page 8:  Certification "]
[]
[null,"This certification page must be signed by the district's Superintendent and Chief Business Official at the time of public disclosure and is intended to assist the district's Governing Board in determining whether the district can meet the costs incurred under the tentative Collective Bargaining Agreement in the current and subsequent years.  The absence of a certification signature or if \"I am unable to certify\" is checked should serve as a \"red flag\" to the district's Governing Board.",null,null,null,null,null,null,"The AB1200 Collective Bargaining Agreement should be presented as a separate board item before the collective bargaining agreement itself is approved."]
[]
[null,"Summary of Financial Impact of Approving the Proposed Agreement(s)"]
[null,null,null,null,{"$f":"'Page 1a, Cost of the agreement'!C13","v":0},{"$f":"'Page 1a, Cost of the agreement'!E13","v":{"$error":"#VALUE!"}},{"$f":"'Page 1a, Cost of the agreement'!F13","v":{"$error":"#VALUE!"}}]
[null,null,"Budget Increases in Objects 1000s, 2000s, 3000s as a result of settlement (p. 1a - 1c), all funds",null,{"$f":"'Page 1 Total - All Agreements'!E26","v":0},{"$f":"'Page 1 Total - All Agreements'!F26","v":0},{"$f":"'Page 1 Total - All Agreements'!G26","v":0}]
[]
[null,null,"All Adjustments included in Disclosure"]
[null,null,"Revenues/Other Financing Sources F01",null,{"$f":"'Page 5c MYP Combined'!G14+'Page 5c MYP Combined'!G27","v":0},{"$f":"'Page 5c MYP Combined'!H14+'Page 5c MYP Combined'!H27","v":0},{"$f":"'Page 5c MYP Combined'!I14+'Page 5c MYP Combined'!I27","v":0}]
[null,null,"Revenues/Other Financing Sources Other Funds",null,{"$f":"'Page 4d Adult Education Fund'!E13+'Page 4d Adult Education Fund'!D25+'Page 4d Adult Education Fund'!E25+'Page 4e Child Development Fund'!E13+'Page 4e Child Development Fund'!E25+'Page 4e Child Development Fund'!D25+'Page 4f Cafeteria Fund'!E13+'Page 4f Cafeteria Fund'!D25+'Page 4f Cafeteria Fund'!E25+'Page 4g Other Enterprise Fund'!E13+'Page 4g Other Enterprise Fund'!D25+'Page 4g Other Enterprise Fund'!E25+'Page 4h Other Fund'!E13+'Page 4h Other Fund'!D25+'Page 4h Other Fund'!E25","v":0}]
[null,null,"Expenditures/Other Financing Uses F01",null,{"$f":"'Page 5c MYP Combined'!G25+'Page 5c MYP Combined'!G28","v":0},{"$f":"'Page 5c MYP Combined'!H25+'Page 5c MYP Combined'!H28","v":0},{"$f":"'Page 5c MYP Combined'!I25+'Page 5c MYP Combined'!I28","v":0}]
[null,null,"Expenditures/Other Financing Uses Other Funds",null,{"$f":"'Page 4d Adult Education Fund'!D23+'Page 4d Adult Education Fund'!E23+'Page 4d Adult Education Fund'!D26+'Page 4d Adult Education Fund'!E26+'Page 4e Child Development Fund'!D23+'Page 4e Child Development Fund'!E23+'Page 4e Child Development Fund'!D26+'Page 4e Child Development Fund'!E26+'Page 4f Cafeteria Fund'!D23+'Page 4f Cafeteria Fund'!E23+'Page 4f Cafeteria Fund'!D26+'Page 4f Cafeteria Fund'!E26+'Page 4g Other Enterprise Fund'!D23+'Page 4g Other Enterprise Fund'!E23+'Page 4g Other Enterprise Fund'!D26+'Page 4g Other Enterprise Fund'!E26+'Page 4h Other Fund'!D23+'Page 4h Other Fund'!E23+'Page 4h Other Fund'!D26+'Page 4h Other Fund'!E26","v":0}]
[]
[null,null,"Projected F01 Unrestricted Surplus (Deficit)",null,{"$f":"'Page 5a MYP Unrest GF'!C30","v":0},{"$f":"'Page 5a MYP Unrest GF'!D30","v":0},{"$f":"'Page 5a MYP Unrest GF'!E30","v":0}]
[]
[null,"Budget Revisions",null,null,null,null,null,null,"Create budget revisions in Escape by generating a new budget model after entering salary increases. Post the model, then print a Ledger 01 report with criteria JE Source \"Budget,\" JE Type \"BudRev,\" and by the posting date for board approval, within 45 days."]
[null,"If the district does not adopt and submit within 45 days all of the revisions to its budget needed in the current year to meet the costs of the agreement at the time of the approval of the proposed collective bargaining agreement, the county superintendent of schools is required to issue a qualified or negative certification for the district on its next interim report."]
[null,"Certifications"]
[]
[]
[]
[null,null,"The information provided in this document summarizes the financial implications of the proposed agreement and is submitted to the Governing Board for public disclosure of the major provisions of the agreement (as provided in the \"Public Disclosure of Proposed Collective Bargaining Agreement\") in accordance with the requirements of AB 1200 and Government Code Sections 3540.2(a) and 3547.5."]
[null,null,"The costs incurred by the school district as a result of this agreement can be met by the district during the term of the agreement. "]
[]
[null,null,"District Superintendent",null,null,"Date"]
[null,null,"(Signature)"]
[]
[]
[null,null,"The information provided in this document summarizes the financial implications of the proposed agreement and is submitted to the Governing Board for public disclosure of the major provisions of the agreement (as provided in the \"Public Disclosure of Proposed Collective Bargaining Agreement\") in accordance with the requirements of AB 1200 and Government Code Sections 3540.2(a) and 3547.5."]
[null,null,"The costs incurred by the school district as a result of this agreement can be met by the district during the term of the agreement."]
[]
[null,null,"Chief Business Official",null,null,"Date"]
[null,null,"(Signature)"]
[null,null,"After public disclosure of the major provisions contained in this summary, the Governing Board at its meeting on",null,null,null,null,null,"This section (line 47 and below) should not be signed until after Board approval.  The top section must be signed before Board approval."]
[null,null,"took action to approve the proposed agreement with the (specify Bargaining Unit(s)):"]
[]
[null,null,"President (or Clerk), Governing Board",null,null,"Date"]
[null,null,"(Signature)"]

{"sheet":"Page 9, Explanations and Other","index":25,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,4,40,5],[41,4,41,5],[42,2,45,5],[2,1,2,5],[4,1,20,5],[21,1,21,5],[22,1,36,5],[37,1,37,5],[38,1,38,2],[38,4,38,5],[40,1,40,2],[41,1,41,2]]}
[]
[]
[null,"Assumptions and Explanations (enter or attach documentation)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Concerns regarding affordability of agreement in subsequent years (if any):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parent/Teacher Organization Contact Information (qualified or negative districts only, attach additional page if more space is needed)*",null,null,"E-mail address"]
[]
[]
[]
[null,null,"*Required for districts with a qualified or negative certification.  Per GC 3540.2, for districts with a qualified or negative certification, the county superintendent is required to notifiy the school district, county board of education, district superintendent, governing board of the school district, and each parent and teacher organization of the district if, in their opinion, the agreement would endanger the fiscal well-being of the school district."]